Forum Discussion
Why there is a delay in Query Begin on Power BI ?
Community SupportHi Anonymous ,
Unfortunately I did not find any accurate parallel running figures supported by the documentation. As far as I know, we should consider queries run in parallel instead of visuals. Because one visual always contains more than one query. And if one query depends on the other query , it will also act like your situation.
To increase parallelism in ssas during querying for servers with multiple processors, consider modifying the Threadpool\Query\MaxThreads and Threadpool\Process\MaxThreads options to be a number that depends on the number of server processors. Please refer to /* Tune processor usage8*/ in https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc966527(v=technet.10)?redirectedfrom=MSDN and https://docs.microsoft.com/en-us/analysis-services/server-properties/thread-pool-properties?view=asallproducts-allversions
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
Hello v-deddai1-msft , I changed the MaxThreads count to a higer number, but still outcome is same. Only 4 queries running in parallel and also seeing a delay in starting of a DAX query through PowerBI. Although there is no document which provides an accurate parallel running figures, but here (https://youtu.be/kkIXtvU1AiM?t=436) Adam Saxton mentioned count of 4. Therefore i would request you to please check further and help me these two issues Concurrency Number and Query Delay.