Issue with Many to Many Relationships in Power BI Report Server - User can no longer open a file

Hi  particleandwave ,

Many to Many relationships are not supported in Power BI Report Server and are not available for selection in the Edit Relationship box. This is why you are encountering errors when trying to open the file again.

To resolve this issue, I recommend the following steps:

1. Remove the Many to Many relationship from the Data Modeling Properties panel: - Open the Power BI file that is causing the issue. - Go to the Data Modeling Properties panel. - Locate the Many to Many relationship that was selected. - Remove the Many to Many relationship by selecting a different relationship type (e.g., One to Many or Many to One).

2. Save and close the file: - After removing the Many to Many relationship, save the changes to the file. - Close the file to ensure that the changes are applied.

The workaround is to create a bridge table with a list of the distinct values from one of your columns (you can do this with a calculated table using an expression like VALUES( table[column] ).then you create a many to 1 and 1 to many relationship chain.

Best regards.
Community Support Team_Caitlyn