The query referenced column which depends on another column, relationship or measure that is not in

[sshan]

Hello Team - I need some help. I have a power bi report that was published successfully and working for over a month.

Starting this morning the report is not showing the data with the below mentioned error.

But when I run the report on desktop I do not have this issue. I can see the data on the online power bi report once I publish the report.

But as soon as i refresh the online dataset the error shows up again.

The report shows the same error below after the dataset is refreshed online. Can someone please help? much appreciated.

The query referenced column xxxxxxxxxxx which depends on another column, relationship or measure that is not in a valid state. Additional information: ''.

[balaganeshmohan]

Did you by chance find any solution for this problem? I am facing the same issue on a calculated column in a import file that getting data from a live connected dataset in direct query mode.

[v-xiaoyan-msft · Accepted solution]

Hi @sshan ,

During our investigation, we found that someone who had a similar problem to yours in the past was able to solve the issue with the Power Bi update via WEB update.

You can view the original Post here The query referenced column ****** which depends on another column 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[vamri]

@v-xiaoyan-msft , i am facing the exact same issue and I do not understand what "Power Bi update via WEB update" means. Could you please explain this to me? Thank you.