How to create inner join relationship in data model?

Hi jaryszek,

Probably late reply but might help others.

I struggled a while with this and found a solution that worked for me:

You need to create a new query and connect the two others through this new one.

1. From your PBI report, click "Transform Data" (ie: open the Power Query Editor)
2. In your query with the ServerClass (as per your example), right click at the top of your ServerClass column, then click "Add as New Query". Only if all of your Server Classes are written in this column, otherwise you will need to merge it with the other column from the other query.
3. In your new query (should be named ServerClass, as per your column), right click at the top of the column and click "Remove Duplicates".

4. Click "Close & Apply". In the Model View, the relationship should get created automatically but you might need to edit it to make the "Cross filter direction" = "Both"

For my application, the model view looked like that:

Connecting the "Retrieval IDs" straight away didn't work... But this solution did it.