Skip to main content

Posts

Showing posts from 2021

Performance Troubleshooting: Tabular Model in Power BI

For the last 2 years, I have been using Power BI as one of the core tools to provide different data insights for the top management.  Together with my great team, I was constantly improving our key reporting tools. As in a classical way we were facing problems with the performance. The rising complexity reflects on the user's response and on the stability of report updates. The Tabular model allows boosting both the performance and the speed of development of massive reports with complicated data models and too many DAX.   Let us consider the use case and different ways of improving report performance including usage of the Tabular model. About DataSet:   Classical OLAP schema - Snowflake  Size of fact table - over 40 mln rows Over 40 dimensional tables Data Connectivity Mode - Import Type of Connector - SQL Server Database The report was hosted in Power BI Report Server.  Ways of investigation and steps to improve the performance: Migrate report from on-premise PBI RS to the Cloud