PBi Service- Disable Parallel Query Loading

[rtpg675411]

It seems "disable" parallel query loading is not supported in PBi Service as in PBi Desktop. I'm a newbie and invested allot of time building several report in PBi Desktop for publishing to PBi Service to find out that my reports can't refresh on PBi Service. I've tried things like "Function.InvokeAfter" and building in artificial dependencies to emulate sequential query execution but it doesn't work. Half my queries are failing as they depend on result of previous queries. Can somebody confirm if "disable" parallel query loading is supported in PBi Service. 

[rtpg675411]

GilbertQ...individual/sequential loading of tables in a PBi dataset not supported on PBi Service. I'm looking to utilizing PBi dataflows to breakup the queries so I can schedule refresh for individual tables on demand; will create dataset from dataflows and create the subsequent report visuals from there. thats the plan anyway. keep you posted. Cheers.

[rtpg675411 · Accepted solution]

Hi GilbertQ, Just to clarify; I have been using the "*one (disable parallel loading)" option on PBI Desktop and dataset has been refreshing without issue in PBI Desktop. But once I publish to my workspace on PBi Service it seems sequential query loading (one by one) setting in PBi Desktop is not effected. I'll try explicitly setting query load count option to "1" as in your screenshot to see if that works . ..thank you for your support.

[GilbertQ]

Hi @rtpg675411 

yes that is the setting in that it will run them in sequential order.

[GilbertQ]

Hi @rtpg675411 

It is certainly working in the Power BI Service. You can make sure to only load a single table by going into the options and then CURRENT FILE -> Data Load and then select One under "Parallel loading of tables"

Please note you do not have to do anything special it will load each table one at a time in the right order.