I have a small data set of 500,000 rows only and still it takes long to load in powerbi service

[singh_gagan30]

HI

TIA

I have a small data set of 500,000 rows and still it takes long to get loaded on powerbi service. I have used import query for the storage mode and got 5 pages which barely have 4-5visuals. The data model has only 20 columns.

Please help me in optimizing the report on powerbi service.

Regards,

[v-xuding-msft]

Hi @singh_gagan30 ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. More people will benefit from here. Thanks in advance.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @singh_gagan30 ,

You could download the report and then use the Performance Analyzer to test and reduce the load time. The Performance Analyzer records and displays how long it takes each visual to render on the page and breaks that time out into categories. You can learn more about how to use the Performance Analyzer and interpret its results from Microsoft's documentation.

And there are other documents that you can reference to optimize your report.

Power BI performance best practices 

Power BI Performance Tips and Techniques

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.