Only Get the Last Few Periods of Data into Power BI using Power Query Filtering

Power BI reports can get slow if you have huge amount of data. One of the ways to speed up the performance is to get the smaller part of the data, only the part that is needed for analysis. Most of the times, a date condition is a good filter for that. You might only Read more about Only Get the Last Few Periods of Data into Power BI using Power Query Filtering[…]

Why my Power BI Matrix or Table Visual is SLOW

You have created a Power BI report with many visualizations and calculations, however, it is slow! And the slowest part of that is the report page with a matrix or table visual in it! Why that visual is so slow? Is this the problem of Visual in Power BI? or Power BI problem at all? Read more about Why my Power BI Matrix or Table Visual is SLOW[…]

Find the Most Expensive Columns for Performance Tuning, Bookmarks, and more with Power BI Helper Version November 2018

We are excited to share you the November 2018 version of Power BI helper with many interesting features. With this version, you get the list of all pages and list of all bookmarks. You can find all bookmarks related to a page. You can also through this version find out the data columns that consume Read more about Find the Most Expensive Columns for Performance Tuning, Bookmarks, and more with Power BI Helper Version November 2018[…]

Watch Your Steps! Power Query Performance Caution for Power BI

I work with Power Query transformations every day these days, and I want to share one simple, but critical caution with you. If you use Power Query a lot, this tip can improve the performance of your transformation significantly. The number of steps that you add in a query counts in the performance of your Read more about Watch Your Steps! Power Query Performance Caution for Power BI[…]

Not Folding; the Black Hole of Power Query Performance

Have you ever thought does your Power Query Transformations happens in the data source side (server side), or on the local memory (client side)? When you use a relational data source, query can be run on the data source, but it depends on transformations. Some transformations can be translated to query language of the data Read more about Not Folding; the Black Hole of Power Query Performance[…]

Performance Tip for Power BI; Enable Load Sucks Memory Up

In the area of performance tuning a Power BI model many things has to be considered, most of them around consumption of the CPU and RAM. One of the most basic but important consideration is minimizing the usage of memory. By default all queries from Query Editor will be loaded into the memory of Power Read more about Performance Tip for Power BI; Enable Load Sucks Memory Up[…]