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!
Hi, would you please provide an update on this issue? I'm getting the same error. I have a PBI dataset in my model. It works in PBI Desktop but getting this error once published in PBI Service and dataset is refreshed.
The query referenced column 'Departments'[Commitments] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''.
Activity ID: d83fcfb7-6779-4986-9e88-67ba1732dfccRequest ID: 6fd59325-3695-30c7-28aa-d043baddfda6Correlation ID: 9931825d-e946-3068-402f-5327c38cdb02Time: Sun Jun 19 2022 21:54:22 GMT-0400 (Eastern Daylight Time)Service version: 13.0.18489.36Client version: 2206.2.11758-trainCluster URI: https://45f26ee5f134439ebc93e6c7e33d61c2-api.analysis.windows.net/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.