Relationship problems after SQL database update

[Anonymous]

Hello,

We did some database updates on our SQL-server on weekend and after that one of the relationship on our massive report stopped working? The problem is, Power BI report has probably over 100 relationships, so I dont know which of the relationships has stopped working.

So one of the calculated columns (which affect to many other measures and columns) informs an error: This expression refers to a Relationship object named '5e2ecc2c-e6dd-4f06-85f8-8a2cd002aec3', which has an error.

What I can do to solve which of the relationships are broken? Can't check all of them because there are approx. 80 tables and everyone is related somehow... 

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Anonymous ，

You can check the below article and see if this helps in finding Metadata using ID

https://radacad.com/exposing-m-code-and-query-metadata-of-power-bi-pbix-file

And refer the following similar question:

https://community.powerbi.com/t5/Desktop/Unknown-Error-using-PATH-Function/td-p/472172 

Best Regards

Lucien