-
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
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
This article describes a simple approach that you can apply to improve your reports and dashboards. Read more
-
This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI. Read more
-
In this article, we share an idea to reduce the friction in using Power BI, by extending the DAX language with new visual calculations. Read more
-
Power BI sets a new milestone in Business Intelligence: Marco describes the importance of new composite models in an article, and Alberto shows them in action in a video. Read more
-
A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in detail the KPI settings needed to get the best result using Power BI and… Read more
-
articleOptimizing text search in DAX
This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains condition in the filter pane or the filter mode of the Smart Filter Pro… Read more
-
articlePower BI is a model-based tool
This article describes the differences between report-based tools and model-based tools. Because Power BI is a model-based tool and not a report-based tool, it is useful to have a quick reference guide explaining these differences. Read more
-
When you create a data model in Power BI, you should consider how to properly use naming convention and what columns to include, in order to improve usability and performance. This article provides a quick list of best practices valid… Read more