Forum Discussion
The query referenced calculated table *** which depends on another column, table, related column
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.
3 Replies
- GilbertQ
Super User
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)
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.
