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

[fileonlineservi]

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

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:-

Any idea?

Thanks

[fileonlineservi]

@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 · Accepted solution]

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