Forum Discussion

mwinkels's avatar
mwinkels
Frequent Visitor
10 years ago
Solved

Calculated Column Relationships

 

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?

 

 

 

Need Help
  • mwinkels's avatar
    mwinkels
    10 years ago

    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.

2 Replies

  • S184019's avatar
    S184019
    Advocate III
    7 years ago

    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's avatar
    mwinkels
    Frequent Visitor
    10 years ago

    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.