The query referenced column XXX which depends on another column, relationship or ...

[MichaelFP]

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-e858f656a1f4
Request ID: cae2d5c2-bcaf-da62-81f5-9f38c19b6d94
Correlation ID: 22b2270a-06f0-47ea-63ea-316c7b991529
Time: Tue Jan 18 2022 14:35:08 GMT+0100 (Central European Standard Time)
Service version: 13.0.17576.19
Client version: 2201.4.09484-train
Cluster URI: https://df-msit-scus-redirect.analysis.windows.net/

[v-robertq-msft]

Hi,

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

ICM: 282924727

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!

Best Regards,

Community Support Team _Robert Qin

[MichaelFP]

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.

[v-robertq-msft]

Hi,

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.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[MichaelFP]

Ticket created: Ticket Form - Core Services Engineering (service-now.com)

[v-robertq-msft]

OK, thanks for your corporation!

[jasonxmba22]

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. 

Couldn't load the data for this visual

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-67ba1732dfcc
Request ID: 6fd59325-3695-30c7-28aa-d043baddfda6
Correlation ID: 9931825d-e946-3068-402f-5327c38cdb02
Time: Sun Jun 19 2022 21:54:22 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.18489.36
Client version: 2206.2.11758-train
Cluster URI: https://45f26ee5f134439ebc93e6c7e33d61c2-api.analysis.windows.net/

[Tlessa]

Spend 2 weeks trying to debug a similar case occuring in my dataset.
Locally wverything was perfect, after publishing the first load was fine but after refreshing got the same message:
"The query referenced column [Column name] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''."

Cound not figure out what it was, searched around many posts staign the same, some telling to chance decimal to  % some telling there was an issue with the related function being called... None of them solved my issue.

Then one day, out of nonwhere I could replicate the issue locally, the same columns as the message above got  an error, however, locally the message was different:

"SummarizeColumns() and AddMissingItems() may not be used in this context"

Then searching around found this post
https://community.fabric.microsoft.com/t5/Desktop/SummarizeColumns-and-AddMissingItems/td-p/2471441

Stating that Summarize and summarizecolumns are not interchangeable wich in turn led to SQLBIs post
https://www.sqlbi.com/articles/introducing-summarizecolumns/#:~:text=UPDATE%202017%2D02,in%20a%20mea...

So I changed from Summarizecolumns to summarized, replublished and it worked as expected.

So the issue was using a summarizecolumns in a filterconext inside a calculated column.

No clue why locally, even though apparently not supported, the summarizedcolumns USED to work fine (and even is reccomended by documentation beacause of performance reasons), but n service it just did not work. Also no clue on how/why it started to fail locally, but thankfully this led me to the solution of my issue.

TL.DR.: 
Check if you are using SUMMARIZEDCOLUMNS() in the function refferenced by the column, if so switch to SUMMARIZE()