Forum Discussion

biremedia's avatar
biremedia
Frequent Visitor
1 year ago
Solved

Not valid column status

Hi everyone, I get the following error on my report visuals: "the query refers to a relationship between Vacation[LeadClientId] and LeadClient[ClientId] that depends on a column with an invalid stat...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    1 year ago

    Hello biremedia ,

     

    what you should do is that download the report from service that has the error, because it happened to me one, that there was some sort of transformation happening when getting published.

     

    so after downloading the version with the issue , go and check the mentioned columns.

  • biremedia's avatar
    biremedia
    1 year ago

    I solved the problem, it was really tricky!

    I created a report connected to the publihed data model in order to study the published data.

    There was a duplicated value in a table where I use a LOOKUP function.

     

    I could not see it in PowerBI desktop due to the different data refresh polices that incremental refresh introduces.

     

    Thank you all for your help!

pallavi_r's avatar
pallavi_r
Super User
1 year ago

Hi biremedia 

 

There could be a column behind this relationship, could be the joining key which is deleted or renamed now. 

There might be a dependent query which needs to be loaded first on the table and this one is refreshing prior to dependent query.

Datatype mismatch also could be a problem

And is the column dependent on a DAX Measure or Calculated tables or if there is hierarchical data?

Can you please give more detail on these table.

 

Thanks,

Pallavi

 

 

Thanks,

Pallavi

  • biremedia's avatar
    biremedia
    Frequent Visitor
    1 year ago

    Hi pallavi_r, thank you for your help.

     

    I think there are no problems with joining key removal/renaming sice it works perfectly in PowerBI Desktop.

     

    The table LeadClient is the result of a simple DAX query: 

     

    LeadClient = Client

     

    where Client is a query from the datasource.
     
    Please, tell me if I can give you more usefull informations.