Power BI Performance Limitations

Well, not a simple question to formulate… but: what’s the top comfort number of elements that Power BI viewer can effectively handle?

We’re working with pretty large models containing thousands of elements, so when I’m putting them into the PBI environment, I’m facing with significant lags (especially while data processing). And what is the way to reduce them? Perhaps some filtering, cleanings etc?

The hardest of hard limits Power BI imposes on all visuals is 30,000 rows. This is the same limit they impose for CSV import/export.

That is not to say that you can’t prioritise the elements passing from the Data Connector to the viewer needs to be as high as the total objects in a commit. The PowerQuery process can prioritise, cleanse and wrangle this to an optimum number.

1 Like