Solved: Disable parallel loading in datamart refresh

LangGergely · ‎11-08-2023

Hello, Community,

I have a problem with datamart refresh in powerBI service.

I have PPU license, and have some datamarts, which are refreshed 2 times a day. (scheduled refresh).

These contains 4- 5 tables. When refreshing, it starts to refresh more table parallel. The source is Odata (Invantive cloud), it works based on API connection. it causes problems, because of the limitations (60 calls / minute)

I would like to refresh the table one by one , not parallel. Is there a solution for that? I could not find any settings for datamart, and didn't find a solution in the topics.

Thank you in advance

lbendlin · ‎11-22-2023

This is a longstanding issue with the Power BI Service in general. It ignores your requests for sequential processing that you may have made in Power BI Desktop (for example)

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 .

View solution in original post

lbendlin · ‎11-22-2023

This is a longstanding issue with the Power BI Service in general. It ignores your requests for sequential processing that you may have made in Power BI Desktop (for example)

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 .