The query referenced calculated table *** which depends on another column, table, related column

[vamri]

Hi all,

I am getting error in Power Bi web which reads: The query referenced calculated table *** which depends on another column, table, relationship or measure that is not in a valid state.

The visuals work fine in Power Bi desktop and the report successfully refreshes in Power Bi web too but then I get this error. I am using M queries and incremental refreshes in this report. I tried following the solution proposed here Solved: The query referenced column ****** which depends o... - Microsoft Power BI Community but was not able to clearly understand the message.

Any help would be appreciated.

[GilbertQ]

Hi @vamri 

It sounds like there is an issue with your calculated table that you have created. I would suggest trying to create the table in Power Query, so that it is not dependant on the calculated table.

Just some more information is when you create a calculated table, when the dataset is refreshed it then has to reload the entire calculated table (And if there is something missing in an underlying table, this will break the calculated table)

[vamri]

@GilbertQ thanks for the suggestion, i will look into it but I also get this error on some visuals The query referenced column *** which depends on another column, relationship or measure that is not in a valid state. Additional information: ''. This column does not come from summary table and works fine in Power Bi desktop.

[GilbertQ · Accepted solution]

Hi @vamri 

That error means that the calculated table is not being successfully refreshed which is causing your issue.