The query referenced a relationship ....,which depends on a column that is not in a valid state

[waltheed]

After I refresh the data in my pbix file I get an error in a table visual:

The query referenced a relationship between ... and .... ,which depends on a column that is not in a valid state.

The dataset was downloaded from the Power BI service. It refreshed fine over there.

I installed the latest version (march 18 2021) of Power BI Desktop.

I do not know a way out of this. Please help. 

Thanks, Edgar

[v-chuncz-msft]

@waltheed 

I tried the latest version and it seems to work fine for me.

[Jewel]

I encounted similar issue that:

The visual works fine in Power BI Desktop but not in Power Serivce.

Connector in Gateway connects fine.

If publish from Power BI Service without Gateway configed, it renders properly.

After Gateway is configued and refresh triggered, it fails to render.

Can anyone share more findings?

Thanks,

Jewel

[Anonymous]

Hi @Jewel and @waltheed !

I had the same issue. The relationship between tables was based on the calculated field which had an error in calculation. I didn't see this error in the Desktop version, but it occurred in Web.

Just add IFERROR() statement to the field which is used in a relationship and has a calculation inside it.

Best regards,

Liza