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

Otavio_bhz's avatar
Otavio_bhz
Regular Visitor
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

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
2 years ago

Otavio_bhz How did you replace? I have the same issue.

So if the column is Decimal number with 2 places after decimal, how to just convert that column as percent and get same result?