Disabled "Parallel loading of tables" is not working (Jan 2021 release)
Hi, "Parallel loading of tables" is not working correctly. When disable "Parallel loading of tables" in section Data Load in Options, it is working correctly in Power BI Desktop (tables are loaded sequentially in correct order). But after Save as to Power BI Report Server (both in Jan 2021 release), and run scheduled refresh, this behavior not working correctly, tables are still loading parallelly. This option is importat when is there many reports refreshing many tables, which can overload datasource, and in cases when is important order of loading. This issue is also present in October 2020 relese (all three builds). Last worked correctly in May 2020 release.Issue: "Loading tables simultaneously" is not working (Sep 2021)
Hello, New function "Loading tables simultaneously" is not working correctly on Power BI Report Server, September 2021 release. When set "Maximum number of simultaneous evaluations" to "1" on "Loading tables simultaneously" settings in section Data Load in global Options, it is not working correctly in Power BI Report Server during scheduled refresh, all tables are loaded parallelly independent on this settings. During development in Power BI Desktop RS it is working well. It is third similar feature which is not working on Power BI Report Server. Also when "Maximum connections per data source" in "Published dataset setting" in Options is set to 1, is not working on Power BI Report Server, and tables are loaded parallelly (in Power BI Desktop RS works well). And also when "Enable parallel loading of tables" in "Data Load" section in Option is disabled, is not working on Power BI Report Server, and tables are loaded parallelly (in Power BI Desktop RS works well and in correct order). See https://community.powerbi.com/t5/Report-Server/Disabled-quot-Parallel-loading-of-tables-quot-is-not-working-Jan/m-p/1862993 This function last worked correctly in May 2020 release of Power BI Report Server, which is not unsupported now. Now, there is no way how to override parallel loading of tables during scheduled refresh on Power BI Report Server. These functions are more important on PBI Report Server, than PBI Desktop, because scheduled refreshes are running daily and typically on fast enterprise LAN, and can easy overload datasource, than from Power BI Desktop (running occasionally on slower network). These options are very important when is there many reports refreshing many tables, which can overload datasource, and in cases when is important order of loading. I think, it is critical issue, because it can overload primary database system, lead to unavailability of source systems.Issue: "Parallel loading of tables" not working after upgrade PBIRS to October 2020(2nd)
Hello, after upgrade Power BI Report Server to version October 2020 (2nd release), when function "Parallel loading of tables" (under options>data load) is turned off, this behaviour is not working. In case when this function is turned off, PBIRS during refresh is still loading parallely. This problem is only on server (PBIRS) side (in Desktop Oct2020 it works well), and is independent on Enhanced Metadata format setting. It is critical issue for me, because in this case is not maintaned order of loading of datasets (which can be important). And bigger problem, in cases of many datasouces are loaded parallely, it's makes huge load on source databases, which can lead to crash primary systems. At this time I do not know any workaround to solve this issue.