Recent Blog ArticlesNewest TopicsMost LikesTagged:TagThe #1 factor in ADX/KQL database performance The most important thing determining the performance of a KQL query is making sure that the minimum part of the data is scanned. In almost all cases a filter on a datetime column is used to determi...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...Timespan/duration values in KQL, Power Query and Power BI In many scenarios event durations are very important. They can be measured in days or in milliseconds and anything in between. In real time analytics it is especially important. In this article...To BE or not to be – case sensitive using Power BI and ADX/RTA in Fabric ADX/Kusto is case sensitive while Power BI is not but Power Query is. Confused? This article takes you through an example with mixed case using Power BI and Power Query. 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. Alte...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 ...How many to many relationships affect the number of queries required to refresh matrices and tables Relationships between tables coming from Kusto in direct query mode are created as M:M by default. Changing them 1:M can reduce the number of queries required for tables and especially matrices. Filtering and visualizing Kusto data in local time Datetime values in Kusto (aka Azure Data Explorer/ADX/KQL database in Fabric) are assume to be in UTC time. In many cases users want to filter the data and see the results using their local time. ...Calculating distinct counts in Power BI with data in Kusto Distinct counts using the dcount KQL function return estimated values. A new setting in Ower BI allows you to control how accurate (and how expensive) these counts will be You can also choose to ...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
MicrosoftMicrosoftMicrosoftMicrosoft
