Forum Discussion

sshan's avatar
sshan
Regular Visitor
4 years ago
Solved

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

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: ''.

  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      vamri
      Frequent Visitor

      Anonymous , 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.

  • 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.