Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @vamri
That error means that the calculated table is not being successfully refreshed which is causing your issue.
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.
Hi @vamri
That error means that the calculated table is not being successfully refreshed which is causing your issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.