Unknown Error using PATH Function

[Nolan_Ebertsohn]

I'm switching between dev\prod environments(databases) using a parameter.  However, once doing so, my data model that worked in dev no longer works in prod.  I get the following error on a calculated column using the PATH function:

Path = PATH('Work Stream'[Workstream ID],'Work Stream'[Parent ID])

This expression refers to a Relationship object named 'e26a89f1-fe16-4189-9cae-f57cb97c5fea', which has an error.

Then on another table a similar issue:

This expression refers to a Partition object named 'Ice Berg Line[Ice Berg Line-6a0f43f7-1dd5-492a-8fff-a59d251bf474]', which has an error.

Any ideas.

Thanks in advance. 

[Anonymous]

HI @Nolan_Ebertsohn,

I'd like to suggest you remove relationships between switch datasource, then rebuild relationship and calculated column after change datasource.

BTW, can you please share more detail information to help use clarify your scenario?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Nolan_Ebertsohn · Accepted solution]

Hi @Xiaoxin Sheng,

I managed to resolve this issue.  It was duplicate data in the production data causing the issue.  Not so clear from the error message.

Thanks for the input.