Forum Discussion
Memorable MemberIssue: "Loading tables simultaneously" is not working (Sep 2021)
Microsoft EmployeeWithout getting into too much detail I believe this is a side effect of the move to "Models with enhanced metadata" you could try to build the report in an older version of Power BI Desktop for Reporting Services with the preview feature turned off (Jan 2020 should have this option). Then upload to your current September version of PBIRS (Do not open in the latest version of Power BI Desktop for RS or it will be upgraded to enhanced metadata.
Long story short the future of Desktop and PowerBI service are models with enhanced metadata and PBIRS had to support this feature as well. However, one of the side effects of adding support was taking on responsibilies for more model features on Power BI Report Server and one of those features that wasn't explicitly supported was "Loading tables simultaneously".
Let me know if the above workaround does or does not work for you. In the meantime I will still follow up on other options with engineering team.
Memorable MemberHi Petebro
additional information about this issue, including repro steps, is in post Disabled "Parallel loading of tables" is not worki... - Microsoft Power BI Community
I'm not sure if this is side effect of EMF. Yes, this issue starts with Oct2020 release, when also EMF has been introduced, but it was not working regardless of EMF has been turned on or off. I tested many of combination (which also consuming lot of my time):
-on PBIRS Oct2020 published from PBIDesktopRS May2020
-on PBIRS Oct2020 published from PBIDesktopRS Oct2020 with EMF Off
-on PBIRS Oct2020 published from PBIDesktopRS Oct2020 with EMF On
-on PBIRS Jan2021 published from PBIDesktopRS Oct2020 with EMF Off
-on PBIRS Jan2021 published from PBIDesktopRS Oct2020 with EMF On
-on PBIRS Jan2021 published from PBIDesktopRS Jan2021 with EMF Off
-on PBIRS Jan2021 published from PBIDesktopRS Jan2021 with EMF On
-and so on with May2021 and now with Sep2021 version (and also with combination with two new similar features)
In all these cases it is not working, independent on PBI Desktop RS version or if EMF is used.
On PBIRS May2020 (and predecessors) it working correctly on Server side.
Meanwhile, development team introduced additional two similar features (see above), which is working in Desktop, nope on Server. Unnecessary.
Only workaround, if I know, is build secondary infrastructure with PBIRS May2020 version, but it is old, and now is out of support.
Our company need to be solved, because it is critical for onpremise infrastructure. We do not need multiple features how control number of connections form desktop of from cloud, because it is not critical for infrastructure. But need to control/limit server-to-server onpremises connections, because these can overload databases.
Please, check options with engineering team, how can be sloved.
Thank you so much,
Josef