Forum Discussion

SR1's avatar
SR1
Icon for Helper I rankHelper I
7 years ago

Power BI visuals taking long time to load

Hi,

I have a collection of reports in a pbix file running in direct query mode.
Out of all, two visuals taking long time(10-15 mins) to load.
The actual query in sql server takes 3 secs to get the rows. I have deleted all the unwanted measures, recreated measures, deleted & reloaded the table in PowerBI. I still have the same issue in both PowerBI desktop & service.
Is there anything else I have to do? Please guide.

Thanks!

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi SR1,

     

    Have you solved your problem?

     

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please feel free to ask.

     

     

    Best Regards,

    Cherry

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi SR1,

     

    Firstly, please check if you have installed the latest version of Power BI Desktop(2.65.5313.1381).

     

    In addition, what two kinds of visual do you use?

     

    If your calculation in power bi is complex, it will casue load slowly.

     

    In addition, you could have a referece of this atricle about  Power BI Performance.

     

    Best Regards,

    Cherry