Which relation does the reference number point to?

[Zyg_D]

After refreshing all of my data I received this kind of error:

This expression refers to a Relationship object named '31445cef-2400-49fa-8c32-a0a250a394ce', which has an error.

The question:
Is there a way to find which relation does the reference number point to?

[vanessafvg]

can you tell us a little bit more about your data model? do you have tables that you have aliased in your model? does it show you were the error is?

[Zyg_D]

---

@vanessafvg wrote:
can you tell us a little bit more about your data model? do you have tables that you have aliased in your model? does it show you were the error is?

---

The question here is not about the error and how to solve it.

The question is about the reference number that is given:
- How to identify the exact relation?
- How to find it written anywhere else than the error message?
- Is there any software/ module/ addin/ etc. which could help?

[FarhanAhmed]

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

[Zyg_D]

Thank you, @FarhanAhmed. This was a really nice option to try. I reviewed every file that I see in the .zip version of my .pbix file, but did not find the reference that I was looking for. 

[v-zhenbw-msft]

Hi @Zyg_D ,

Please refer this thread, hope it helps.

https://community.powerbi.com/t5/Desktop/This-expression-refers-to-a-Relationship-object-which-has-a...

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.