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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi I have a similar Issue. I have a master data where i have price field. I joined this with Transactional data with a joining key. and then used related function to bring price in transactional table. I have given data type as decimal number with 2 decimal places. It works fine in Power BI desktop, but wehn kept on schedule in service, it is blowing off the visuals. Can some body help this??