Forum Discussion
Couldn't load the data for this visual errors coming up when accessing reports in the Service
Hi,
Getting the following errors when trying to access the reports in the service:
Couldn't load the data for this visual
Unable to convert an M query in table 'analytics v_ARGeneral' into a native source query.
- Activity ID8cd0c42b-bd57-410d-88cc-c973bd8f714b
- Request ID5a156420-7605-a022-f0b6-0045fa2f6eec
- Correlation ID47f0c5ea-3899-b31f-dd2b-7eb1d3591a07
- TimeMon Dec 14 2020 09:17:59 GMT+0200 (Eastern European Standard Time)
- Service version13.0.14905.74
- Client version2011.5.04066-train
- Cluster https://wabi-north-europe-g-primary-redirect.analysis.windows.net/
This started today 14.12.2020, and the thing is that everything worked fine until this weekend. Has there been any updates to the Power BI Service during this weekend? Reports work just fine in Power BI Desktop but not in the Service.
I am using Direct Query from an Azure SQL as source.
- Anonymous5 years ago
Hi,
I got back to Microsoft Support with my findings and after further investigations, they found out it is actually a bug.
Below is a snippet of the email I received:
Greetings from Microsoft!
We have received an update from our Product team after their complete investigation stating that it is a bug.
Power BI Users using Direct query mode and having Table.ReplaceValues in their partition queries, may experience visual loading failures with an error "Unable to convert an M query in table 'TableName' into a native source query.
The ETA for the bug fix will be deployed by end of the December 2020.
5 Replies
- AnonymousNot applicable
Hi Anonymous ,
Did you make any change on your report and republish it to Power BI Service? Whether upgrade the version of your Power BI Desktop recently before republish the report? Could you please share the applied codes of table "analytics v_ARGeneral" in Advanced Editor in order to make troubleshooting? Thank you.
In addition, there is a similar thread here. Please check the content in the following link, hope it can help you.
Storage mode mixed Direct Query issue with multiple users
Best Regards
- AnonymousNot applicable
Hi,
No I didn't do any changes or updates during the weekend. Everything worked fine before but the error appeared on Monday.
Here is the code from the advanced editor:
let Source = Sql.Database("XXXXX.database.windows.net", "XXXXXXXXXXXXXXX"), analytics_v_ARGeneral = Source{[Schema="analytics",Item="v_ARGeneral"]}[Data], #"Replaced Value" = Table.ReplaceValue(analytics_v_ARGeneral,#datetime(1900, 1, 1, 0, 0, 0),null,Replacer.ReplaceValue,{"Last Settlement Date Real"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",#datetime(1900, 1, 1, 0, 0, 0),null,Replacer.ReplaceValue,{"Due Date"}), #"Filtered Rows" = Table.SelectRows(#"Replaced Value1", each true), #"Replaced Value2" = Table.ReplaceValue(#"Filtered Rows",0,null,Replacer.ReplaceValue,{"Settled Amount Invoicing Currency"}), #"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2",0,null,Replacer.ReplaceValue,{"Settled Amount Home Currency"}), #"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3",0,null,Replacer.ReplaceValue,{"Settled Amount Reporting Currency"}) in #"Replaced Value4"I've narrowed it down to the Replace Value lines. They are causing the errors. It's basically a cleanup of dates and 0 values. When I remove them and republish, everything is working fine. Strange thing is that they worked fine before.
I submitted a ticket to Microsoft and they are looking into it right now.
- AnonymousNot applicable
Hi Anonymous ,
Thanks for sharing these information. Hope your problem can be resolved as soon as possible. Are you willing to share the solution if it is resolved later? This will help others in the community who encounter similar problems find a solution fast. Thank you.Best Regards
- AnonymousNot applicable
Hi,
I got back to Microsoft Support with my findings and after further investigations, they found out it is actually a bug.
Below is a snippet of the email I received:
Greetings from Microsoft!
We have received an update from our Product team after their complete investigation stating that it is a bug.
Power BI Users using Direct query mode and having Table.ReplaceValues in their partition queries, may experience visual loading failures with an error "Unable to convert an M query in table 'TableName' into a native source query.
The ETA for the bug fix will be deployed by end of the December 2020.
- MarianFrequent Visitor
The a similar issue. I use a Mixed Storage mode (connecting the report to a Dataset in the Premium Workspace and some Dataflows in the same Premium Capacity Workspace.
Then the published report in the same Premium Workspace shows all visuals to all people only with Pro license. Free users cannot see the visuals and they receive this error of Data could not be loaded.
The same report , using directly imported data worked for all users in the same Workspace, including free users.
It looks like a report based on another Direct connect Dataset , or mixed storage mode with a connected model from a Premium space published Dataset, does not allow the non-pro users to consume the data from the Dataset , despite the fact both the report(connected to the Dataset) and the connected Dataset itself are in the same Premium Capacity Workspace!