Forum Discussion

Otavio_bhz's avatar
Otavio_bhz
Regular Visitor
9 years ago
Solved

The query referenced column ****** which depends on another column

Hi all,   I have updated done my query in power bi destop and worked well. But when I upload that, works well to, but when I update from the web, it appear the foollowing message:   The query re...
  • Otavio_bhz's avatar
    Otavio_bhz
    9 years ago

    Hi All,

     

    I could solve the issue with the Power Bi update via WEB update.

     

    The problem was that on desktop, if you use int values on imported files those “variables” works fine.

     

    But when you upload that and update, the web system don’t understand as int, and the problem come when you use related() and calculation.

     

    Then I have changed all the columns from integer to number % and everything is fine now on the Web.

     

    Thank you very much for your help,

     

    Kr,

     

    Otávio

RHOU's avatar
RHOU
Icon for Advocate IV rankAdvocate IV
3 years ago

I have the same issue. My model includes imported tables as well as a live connection to an additional PowerBI dataset with relationships between the two. When I use the calculated field directly in a visual, the error changes slightly: "The query referenced calculated column XXX which does not hold any data because evaluation of one of the rows caused an error."

 

The issue started, when I added a calculated column in my imported tables that pulls data from the live connection dataset. 

 

Therefore, I'm guessing that the refresh on Desktop can properly handle this, but on the Service the calculated column is not properly calculated. 

For the other ones that have this issue, do you also have calculated columns that access some tables that are connected via live / direct query model?