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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

This expression refers to a Relationship object named 'xyz', which has an error.

Submitted by Anonymous on ‎07-22-2022 10:44 AM

I had a powerBI report that was working smoothly, but when refreshed recently, it throws this error:

 

"This expression refers to a Relationship object named '932fd216-9e83-4e45-9d1c-f978baa7d4c5', which has an error."

 

Not sure how to look up this 'Relationship object' or how to even get started with this error since the report is exactly the same, but the refresh pulled in new data. The root issue seems to be a column used for a relationship that is throwing this error only after the report is refreshed to the latest data:

 

"A table of multiple values was supplied where a single value was expected."

 

Anyone have any idea how to resolve this issue?

 

 

Status: Investigating
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎07-24-2022 08:14 PM

Hi @Anonymous 

You mentioned a column , It is a calculated column ? Is this problem happening in Desktop?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎07-25-2022 04:16 AM

Hi @Anonymous ,

 

Yes, the column is a calculated column that contains data as expected, but after the refresh is populated only with errors. The problem is in PowerBI desktop. 

 

- Aagney

Anonymous
Not applicable
‎07-26-2022 12:20 AM

Hi @Anonymous 

Can you provide your formula in detail?

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses