Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Why there is a delay in Query Begin on Power BI ?

I have a PowerBI report published on PowerBI Service, this report is connecting to On-Premise SSAS Tabular Model cube. This report has 10 visuals, here are my observations when an user opens the repo...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ï¼Œ

 

In my environment, it is different from yours:

 

 

In my option, it is also related to number of CPU cores.

 

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

 

Best Regards,

Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    v-deddai1-msft That's may be because your visuals might be simple ones (meaning DAX might be completing quickly within few seconds or milliseconds). also don't run the report on PowerBI Desktop because it runs all the queries in parallel and we are seeing this issue on PowerBI Service. Therefore please run the report on PowerBI Service or Reporting Server only. 

    To replicate my scenario, you can intensionally put 8-10 visuals and each of these visual's DAX should take atleast 5 or 10 seconds duration. that's when you would see that it is starting only 4 queries in parallel and maintaining that concurrency also you might get to see some delay in query starting as reported by me. Please keep me posted 🙂