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.
MySQL Database:- Fatal error encountered during data read from (PHPMyAdmin remote Mysql) of CPanel to Power BI.
My data file size is approximately 500 MB and it has over 15lakh records. I want to import this file into my power bi desktop. But I got fatal errors continuously. Here, I got the following message:-
1. Error message:
Fatal error encountered during data read.
Microsoft.Mashup.Evaluator.Interface.ErrorException
True
2. Formulas:
section Section1;
shared #"pagesite_xotik user_sales_order" = let
Source = MySQL.Database("cp-2.webhostbox.net:3306", "pagesite_xotik", [ReturnSingleDatabase=true]),
pagesite_xotik_user_sales_order = Source{[Schema="pagesite_xotik",Item="user_sales_order"]}[Data]
in
pagesite_xotik_user_sales_order;
please help me out here !!!!!!!