Forum Discussion

subhadip's avatar
subhadip
Helper II
8 years ago

Performance Issues in Power BI Desktop

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 .

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi subhadip,

     

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

     

    Regards,

    Frank

    • subhadip's avatar
      subhadip
      Helper II
      8 years ago

      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.