pbi

14 Topics

Using .show queries to understand and optimize the KQL sent from PBI to Kusto
You use Kusto /ADX / KQL databases in Fabric with Power BI. You want to see the queries send to the backend from PBI and try to optimize the behavior. This article includes a query starting with the ".show queries" command that can help you identify the queries that need your attention
DanyHoter
Jun 01, 2023 Place Azure Data Explorer Blog
4.3KViews
2likes
0Comments
Using KQL query settings in Power BI
When defining a query from Kusto/ADX/KQL database, you can include settings that influence the query behavior. The article explains the different kinds of properties and how they are used in cases that multiple M queries are joined.
DanyHoter
Dec 20, 2023 Place Azure Data Explorer Blog
4.3KViews
0likes
0Comments
Best practices in creating aggregations in Power BI and ADX
Aggregations can be created in many ways: writing KQL, Group By in PQ, DAX measures What are the pros and cons of each method and what can go wrong?
DanyHoter
Jun 26, 2022 Place Azure Data Explorer Blog
4.3KViews
0likes
0Comments
To Star or not to Star, More about data modeling in Power BI using ADX
Additional recommendations about best practices when using PBI to access data from ADX
DanyHoter
Dec 05, 2022 Place Azure Data Explorer Blog
4.2KViews
0likes
0Comments
Power BI modeling with ADX - cheat sheet
Modeling with ADX is not the same as modeling with imported data. This article contains recommendations for creating relationships and usage of data types that will provide the best performance
DanyHoter
Mar 15, 2023 Place Azure Data Explorer Blog
3.8KViews
0likes
0Comments
Connecting from Power BI to ADX on a private end point
Many organizations choose to configure Azure Data Explorer(aka ADX aka Kusto) clusters on a private end point. Connecting to these clusters from Power BI is possible but will require using a data gateway.
DanyHoter
May 08, 2023 Place Azure Data Explorer Blog
3.5KViews
0likes
0Comments
How Date and Time values from ADX are reflected in Power BI
Date and time values are maintained in different ways in different tools and databases, In this article I explain how the different data and time ADX data types are handled in Power BI
DanyHoter
Aug 27, 2023 Place Azure Data Explorer Blog
3.5KViews
0likes
1Comment
Why are 273 queries needed to refresh one chart in Power BI ?
A real case from the field in which a huge number of queries were send to an ADX database for refreshing a single visual. The reason was a wrong choice of storage modes for dimension tables. Alternative solutions are suggested at the bottom of the article.
DanyHoter
Jan 23, 2024 Place Azure Data Explorer Blog
3.1KViews
0likes
0Comments
What's wrong with 1:M relationships between ADX tables In Power BI
1:M relationships are the default in PBI and are always recommended. Using ADX, 1:M relationships can cause bad queries. THis article explains why and what can be done to mitigate.
DanyHoter
Feb 26, 2023 Place Azure Data Explorer Blog
3KViews
1like
0Comments
How to use M dynamic parameters without most limitations
In the article and the example, I show how to feed more than one parameter from a single table and a single slicer. Selecting the values is done in a friendly way for the user, and a few more steps for the PBI developer.
DanyHoter
Apr 18, 2024 Place Azure Data Explorer Blog
3KViews
1like
0Comments