Solved: Calculated Column Relationships

mwinkels · ‎06-21-2016

I'm trying to set up a relationship between two tables. One of the tables relies on a calculated column. When I try to set up the relationship, I get the following error: "The expression refresnced column [name of column] which does not hold any data because it needs to be recalculated or refreshed".

I have refreshed the dataset many times and have verified that the column does indeed hold data. Has anyone ever seen this error before? Any workarounds?

mwinkels · ‎06-23-2016

I'm still not sure why this is the error I am given, but I stupidly had a relationship of one to many when I needed to have a many to one.

In the end, changing this relationship type fixed the issue. The error still seems strange to me, but if you face the same thing, make sure to pay attention to the relationship types.

View solution in original post

S184019 · ‎03-26-2019

@mwinkels

I have the same error for data coming from a SINGLE table. There are no references to be refreshed. Microsoft!!! Hep me hep me. This error occurs when viewing the data in the table from PBI online.

mwinkels · ‎06-23-2016

I'm still not sure why this is the error I am given, but I stupidly had a relationship of one to many when I needed to have a many to one.

In the end, changing this relationship type fixed the issue. The error still seems strange to me, but if you face the same thing, make sure to pay attention to the relationship types.