Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Relationship not being used

Hi, 

 

I changed the datasource in my BI report, and now the report does not seem to be using my relationship between Suppliers and Orders, (supplier number) *:1 (one direction suppliers -> orders). As my reports are supplier oriented, this means that the data is not being shown in the reports as associated to the different supplier numbers. I have checked that there are order numbers for the corresponding suppliers, and that they are exactly the same (no extra spaces etc). I'm a bit stuck as to why else BI wouldn't be using the relationship to enable me to bring data. 

 

To give you an idea, my table has supplier numbers, then a count of orders, etc. 

 
3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @Anonymous ,

 

How about reload your tables?

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

Delete and create relation again and check is it still 1-Many or active

Anonymous
Not applicable

Hi, 

 

I already tried that, and yes it still is. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.