topic Re: The query referenced column which depends on another column, relationship or measure that is not in in Report Server

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

sshan — Tue, 02 Aug 2022 23:58:06 GMT

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

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

Anonymous — Fri, 05 Aug 2022 06:09:36 GMT

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.

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

vamri — Tue, 18 Oct 2022 14:52:05 GMT

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.

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

balaganeshmohan — Thu, 27 Oct 2022 13:03:20 GMT

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.