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

ahabelow's avatar
ahabelow
Frequent Visitor
1 year ago

Hi all, 

 

Enabling granular access control at the semantic model level resolved a similar issue for me: Microsoft - Granular Access Control with no extra dev re-work required. In workspace -> click on elipses of semantic model -> settings -> Data Connections -> turn toggle on.

 

Hope this helps others!

AnnMarie