Skip to main content
Microsoft Idea

Power BI

Needs Votes

Need option to disable Parallel loading of tables in PBI Service

Vote (96) Share
TFitz's profile image

TFitz on 12 Sep 2018 21:24:34

We have a data set which pulls data from several objects in Salesforce. Refresh works beautifully in PBI desktop but fails in the PBI service - manual or scheduled refresh. The failure message occurs on different tables and we've determined it's due to the Salesforce limitation that only 10 queries can be run at one time for one user. If the data set goes above 10, you get the infamous "invalid query locator" error message.

Refresh works on the PBI Desktop because you have the ability to disable the "Parallel loading of tables." You don't have the same option in the service.

Microsoft support has advised that they are aware of the issue and it is on their backlog with no ETA of implementation.

Please vote so we can get this implemented! I'm sure others must be having same issue regardless of your data source.

Thanks!

Comments (11)
TFitz's profile image Profile Picture

Abhijith SREENIVASAN on 16 Feb 2022 13:24:52

RE: Need option to disable Parallel loading of tables in PBI Service

Impacts performance and huge disadvantage for use cases requiring operational data. Please implement the feature to disable parallel loading from power BI service as soon as possible

TFitz's profile image Profile Picture

Amit Kfir on 04 Feb 2022 20:43:06

RE: Need option to disable Parallel loading of tables in PBI Service

this issue is KILLING me. please fix it ASAP.

TFitz's profile image Profile Picture

David Salaun on 27 Jan 2022 07:47:16

RE: Need option to disable Parallel loading of tables in PBI Service

That would be such a live safer, please implement!

TFitz's profile image Profile Picture

Georgios Kontokotsios on 26 Jan 2022 16:18:39

RE: Need option to disable Parallel loading of tables in PBI Service

We would really appreciate it if you fixed this issue.Thank you in advance!

TFitz's profile image Profile Picture

Gregor Sieber on 26 Jan 2022 15:49:16

RE: Need option to disable Parallel loading of tables in PBI Service

This is a crucial feature for us, please make it available!

TFitz's profile image Profile Picture

Andreas H on 26 Jan 2022 15:12:59

RE: Need option to disable Parallel loading of tables in PBI Service

Oh yes, please fix that.Thanks!

TFitz's profile image Profile Picture

Mathias Legerer on 26 Jan 2022 14:27:13

RE: Need option to disable Parallel loading of tables in PBI Service

We have also the same issue. It makes no sense to not have the same option as in the desktop variant...Thank you!

TFitz's profile image Profile Picture

Marius Micsa on 16 Dec 2021 06:38:00

RE: Need option to disable Parallel loading of tables in PBI Service

Come on Microsoft, this needs to happen, it's pretty stupid that PBI service ignores this option. Please fix it as I can't automate the update because of this.

TFitz's profile image Profile Picture

HECTOR JOSE ARREDONDO REYES on 10 Jul 2020 17:22:49

RE: Need option to disable Parallel loading of tables in PBI Service

Hello, Did you get response about this issue?

TFitz's profile image Profile Picture

Teresa Fitzpatrick on 06 Jul 2020 00:05:03

RE: Need option to disable Parallel loading of tables in PBI Service

Any update? It's over a year since I posted this. Refresh of Salesforce data still doesn't work. Why bother having the option if it doesn't work?