Semantic Model PBI Service Refresh 5x Longer than Desktop Refresh

[b2wise]

Hi all,

I've done some research on my own but need a little help to figure this out. I have a dataset that takes 3 minutes to refresh in desktop but 15 minutes to refresh in PBI service.

I did some digging and found this excellent article by Phil Seamark. I ran a trace on the refresh in Desktop and in the service and the conclusion I'm coming to is that not enough slots are being used in the service. I don't really know where to go from here and would apreciate some guidance.

Desktop

vs Service

Notice how there are much less slots (highlighted in green) for the refresh to use in the service.

How do I speed up my refresh to match desktop?

Thanks!

[b2wise]

Hi, @Anonymous, I opened a ticket with Microsoft. After initially telling me that this didn't look right they came back a couple of weeks later and said "Nope, this is normal, refresh in the service takes longer and there is nothing you can do about it other than maybe upgrading your tier". So that's that. You can mark this as the solution if you'd like.

[Anonymous]

Hi @b2wise 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

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

[b2wise]

@lbendlin My Power BI data is stored in Virginia East 2. I couldn't find where my sharepoint data is stored, might have to ask IT. But let's say they're also stored in the same place, then what?

[lbendlin]

In that case you will want to raise a ticket. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[b2wise]

@lbendlin I don't know. How would I find that out?

[lbendlin]

In the Power BI service click the question mark, then "About Power BI".  Check where your data is stored.

[b2wise]

@lbendlin No gateway. The data sources are dataflows, sharepoint files, and a datetime API.

[lbendlin]

Which cluster is your capacity running on?  Is your Sharepoint on the same cluster?

[lbendlin]

Is there a gateway involved? If yes, what is the network topology and latency?