Power BI Service refresh 3/4 times slower than Desktop

[gautb33]

Hello Power BI Community, 

I am working on a dashboard for my team that is currently going through optimisation. 

I was doing a complex calculation with SUMX to calculate values at constant rate from historical that I managed to optimise from 14 seconds update to 4.5 seconds (there are 5 matrix on the page with many measures) which is acceptable for my customers. This was done thanks to Dax Studio on my Desktop (please see query result 1).

Precisions: my computer has the following specs: 

When I published my dashboard, this refresh time went up to 12-15 seconds which is 3 time more and not at all the result expected (please see query result 2). I don't have access to the capacity management, talked to my IT team they shown me that we are not reaching capacity limitation and we are currently on P2 8-vcores... (We share the capacity throughout the company). To time the query I took the exact same one than on Dekstop, connected Dax Studio to the workspace and ran it on it. 

I can't understand what's going on, I know that everything was updated 2 weeks ago to Sep. 21 release and it seems to have a slowness effect on all my reports. Would you have any idea to help me? What could be driving that speed difference?  

Thanks a lot for your help!

All the best

[v-henryk-mstf]

Hi @gautb33 ,

In powerbi service, there are many factors that affect the query response time. Usually it takes a little longer than in powerbi desktop. Network latency, different browsers, the dax function itself. Even different connection modes (e.g. direct query mode, where the query time depends on how long it takes for the back-end data source to respond to the query) can all have an impact.

Check out the following blogs for more information.

Chris Webb's BI Blog: Testing Performance Of Power BI Reports In The Browser, Part 1 Chris Webb's BI...

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

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

[gautb33]

Hi @v-henryk-mstf , 

Thanks for your reply. I understand it can take a little bit longer than in Desktop but here we are talking about 3-4 times more... I use Chrome and all my queries are in import mode, not direct query.

I already read the post you moentioned with no improvement... I can't really share data as it is confidential but basically the formula consists of calculating a value from an historical rate to a constant rate with a lookup value on 55 k lines with a sumx. 

To be honest with you, I would be happy if it was "a little bit longer" as you mentioned but here the difference is too much and I wonder if somehting is going wrong... 

How could we proceed? 

Thanks a lot. 

Gautier

[gautb33]

Up please, I can't understand what's going on, I would really like to get some of your knowledge to try to understand... 

Thanks a lot! 

All the best