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

IncursioML1's avatar
IncursioML1
Icon for Helper I rankHelper I
5 years ago

This seems to be happening to me too and I just updated to the latest version on the desktop to see if that was the problem.  

Creating the report in PowerBI Desktop, then publishing to Cloud is fine.  Once you do any type of refresh, whether manually or through the scheduled refresh - the visuals just bomb out.

The only way that seems to be a workaround is refreshing the report in the desktop then publishing to the cloud.

Not sure if this is a bug or if it's relating to all those date/time reference problem or something else I'm missing.

I have 2 datasets, one from SharePoint Online (from a list) and one from SQL Server On Prem. The SharePoint Online is imported and then a relationship made to get some end reporting.  When I had split these two datasets to two different pbix files and refreshed them through the cloud scheduling - it works fine.  

Even tried converting the direct queries to imports and that still didn't work.  The part that is frustrating is that the message isn't very helpful and on top of that the refresh works - it doesn't throw an error, but the visuals aren't loading.  (really?!)