Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |