The query referenced calculated column which does not hold any data because evaluation of

[mshofner]

I have a large dataset that feeds about 40 reports and contains company structure hierarchy. The hierarchy is created using the PATH() function in my data model. Recently, all visuals that reference the hierarchy in any way (path or columns for each level) have stopped working and give error:

"The query referenced calculated column 'Table'[Path] which does not hold any data because evaluation of one of the rows caused an error." 

The dataset refresh does not fail. When I create visuals in the original report that contains the model in PowerBI Desktop, it works fine, but when I publish it to web service, this breaks the visuals in both the original report and all connected reports. All tables that build the hierarchy are coming from the same database (no Excel), and I cannot create the column in PowerQuery. All data types are text for the hierarchy, and when I rebuild the same model and create the same path column in another dataset, there are no issues. The dataset has existed for months and there have been no issues until a few days ago. Can anyone help? Thanks!

[TomMartens]

Hey @mshofner ,

the only reason I can imagine why it stopped working is the following:

An item has two different parents.

I assume you have to check if there are rows where one item has different values as a "parent".

Hopefully, this provides an idea of how to tackle your challenge.

Regards,

Tom

[mshofner]

Hey @TomMartens, my question would be as to why the dataset itself does not fail on refresh? I can refresh in both destop and web service and it goes through, it just breaks visuals. The hierarchy looks to be fine and the column that pulls the single direct supervisor does not break anything, only when PATH() is used. Does that bring anything else to mind?