Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

waltheed

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

Submitted by Impactful Individual on ‎04-09-2021 06:19 AM

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

 

 

 

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎04-12-2021 02:25 AM

@waltheed 

 

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

 

Jewel
Regular Visitor
‎10-20-2021 06:08 AM

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
Not applicable
‎03-25-2022 04:39 AM

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

 

 

Idea Statuses