Topic: DirectQuery
-
Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used. Delivered by Marco Russo at SQLBits 2024. Watch now
-
This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. Read more
-
The second edition of the Optimizing DAX video course is available: new content, a new book, and some on the behind-the-scenes of the project. Read more
-
Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
-
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. In this article we introduce the architecture of push datasets. Read more
-
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. This video introduces the architecture of push datasets. Watch now
-
This article describes how DAX Studio can analyze the SQL queries sent to a relational database by Power BI or Analysis Services Tabular in DirectQuery mode. Read more
-
This article describes the behavior of the COMBINEVALUES function in DAX, and how it can optimize the performance of DirectQuery with multi-column relationships. Read more
-
This article describes a few query limits existing in DirectQuery for both Power BI and Analysis Services Tabular 2016, explaining when you can modify them. Read more
-
This white paper describes how to use and optimizing DirectQuery with Analysis Services Tabular. Read more
