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
9 years ago

Otavio_bhz

 

Do you use on prem sources or online sources for your model?

And what kind of sources? (Excel, SQL etc.)

Otavio_bhz's avatar
Otavio_bhz
Regular Visitor
9 years ago

Anonymous,

 

I am using both.

 

Excel and SQL, but the problem is only with this report.

 

The other reports have mixed database source (SQL and EXCEL) and are working correctly when I update Desktop and when I update web.

 

The only problem is with one report and with a database that use a related function. That mix Excel and SQL functions.

 

And that happend just in WEB update, on the update from power bi desktop works fine (Both gateway and SQL).

 

Please let me know your thoughts.

 

Thank you very much,

 

KR,

 

Otávio.

 

 

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Otavio_bhz

     

    What kind of update you have made on Power BI Service?

     

    If the error message mentioned a LocaDateTime column, it might be the date type or "out of bound" issue. Please refer to similar threads below:

     

    https://community.powerbi.com/t5/Desktop/Date-Hierarchy-couldn-t-load-the-data-for-this-visual/td-p/63257

    http://community.powerbi.com/t5/Desktop/On-calculated-field-using-the-date-hierarchy-causes-an-error/td-p/37824

     

    Regards,

    • Otavio_bhz's avatar
      Otavio_bhz
      Regular Visitor
      9 years ago

      Hi, 

       

      It is not related to date hierachy.

       

      I don't know what could be happening.

       

      Someone have some guess ?

       

      Thank you  very much,

       

      KR,

       

      Otavio

      • 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