PATH Function Error

[Nolan_Ebertsohn]

Unknown Error using PATH Function

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 as I cannot find any details pertaining to this issue anywhere. Bug?

Thanks in advance. 

[Nolan_Ebertsohn]

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 as I cannot find any details pertaining to this issue anywhere. Bug?

Thanks in advance. 

[v-qiuyu-msft]

Hi @Nolan_Ebertsohn,

I tested on my side, if the table structure and data are the same in the dev and prod databases, as long as the PATH function works when connecting to dev, after changing query parameter values to get data from prod, the calculated column works as well. 

Please update your Power BI desktop to the July version then test again. Also please check if the table have the same data both in dev and prod. 

Best Regards,
Qiuyun Yu