Forum Discussion
Couldn't load the data for this visual errors coming up when accessing reports in the Service
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.
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!