Performance Issues in Power BI Desktop

[subhadip]

We have created Power BI dashboard report having 10 controls (Table,Card,Line Chart & Pie Chart) .  The data has been imported in Power BI Model which consists of around 12 Entity holding 3 months of data only.pbix File Size is 7 MB as of now .

When the report  open ,the control spins and it takes couple of minutes to load the data. We have use IMPORT mode since data volume is not that huge and the SQL view takes time if we go by DIRECT connect .

Dashboard connects to On Prem SQL SERVER with data feed as Views .

Please suggest how we can reduce the render time .

[v-frfei-msft]

Hi @subhadip,

You can adapt these best practices to your specific scenario, for more details, Please check the blog.

Regards,

Frank

[subhadip]

best practices we haev taken care off. Need to know if any setting or hardware need to be upgraded to meet the  performance issues.

We are using 8 GB RAM Multi Core Processor.