cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fileonlineservi
Regular Visitor

Can not display the data becuase Power BI can not determine the relationship between two or more fie

I have added 2 separate SharePoint lists inside my Power BI desktop, as follow:-

 
 

image.png

 

now there is not any relation between the 2 tables. and i built 2 tabs inside Power BI >> each table to show the data in a table format >> then i publish the reports.

but when i access the reports inside my workspace >> one tab is working well , while the other is raising this error:-

 

image.png

Any idea?

Thanks

1 ACCEPTED SOLUTION
MDodds
Resolver II
Resolver II

Hello,

 

I think most likely one of two things:

 

  1. Your table visual has a column from both data tables in it accidentally and as a result does not know how to join the data.
  2. You have a filter from the other unrelated data table applied in the filter pane and that is causing power bi to not know how to apply it.

 

Double check those two things. If still not working I am happy to look at the pbix file to resolve.

 

Cheers

 

View solution in original post

2 REPLIES 2
fileonlineservi
Regular Visitor

@MDoddsi re added the data source and it worked, seems what you mentioned is the case, but i find it easier to remove and readd since i just created the report.. thanks a lot for your help.

MDodds
Resolver II
Resolver II

Hello,

 

I think most likely one of two things:

 

  1. Your table visual has a column from both data tables in it accidentally and as a result does not know how to join the data.
  2. You have a filter from the other unrelated data table applied in the filter pane and that is causing power bi to not know how to apply it.

 

Double check those two things. If still not working I am happy to look at the pbix file to resolve.

 

Cheers

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.