PowerBI works perfectly from PowerBI Desktop. After publishing it works for a while (10m to hours). Then all visuals start failing with "Couldn't load the data for this visual"
Note: The pbix uses the preview feature "DirectQuery for Power BI datasets and Azure Analysis Services (preview)"
The query referenced column XXX which depends on another column, relationship or measure that is not in a valid state. Additional information: ''.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 8f9d45a0-4bf0-4493-a3e5-e858f656a1f4Request ID: cae2d5c2-bcaf-da62-81f5-9f38c19b6d94Correlation ID: 22b2270a-06f0-47ea-63ea-316c7b991529Time: Tue Jan 18 2022 14:35:08 GMT+0100 (Central European Standard Time)Service version: 13.0.17576.19Client version: 2201.4.09484-trainCluster URI: https://df-msit-scus-redirect.analysis.windows.net/
According to my research, a similar issue has been reported internally
Problem description: Customer has an intermittent issue of visuals failing to load (Couldn`t load the data for this visual)
Feature(s) involved: Power BI Service - Premium Capacity – DirectQuery
In the latest update of this ICM, the engineers are still investigating this issue.
I will update here once I get any information.
Thank you very much!
Community Support Team _Robert Qin
Any news for this - it is blocking our internal work. My team pings me daily for status on this.Please note that the issue is NOT intermittent. These visual do NOT come back online. Only way to recover is to republish, and that only helps for a very short duration (<1 hr). Don't hesitate to reach out if needed.
According to the latest update, the engineers are talking with the customers to try to re-design and optimize their data model to find a solution to this issue. So I think this is an issue that targeted at their specific data model and Power BI report.
In my opinion, if you want to get a solution for this kind of visual display problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft to have a remote session them to help you to make sure if this is an issue existing in the Power BI.
Ticket created: Ticket Form - Core Services Engineering (service-now.com)
OK, thanks for your corporation!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.