Not valid column status

[biremedia]

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 state."

I cannot understand what is happening.

In powerbi desktop it works, and even in the web just after publishing.

I get the error when the first data refresh completes in the web.

How can I understend why the column has a non-valid status to be able to fix it?

Thank you!

[Idrissshatila · Accepted solution]

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 · Accepted solution]

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!

[Idrissshatila · Accepted solution]

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]

Hi @Idrissshatila,

unfortunately I cannot download the report since it is configured with incremental refresh.

What else can I do?

Thank you for your help!

[pallavi_r]

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]

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.