Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a dataset which was working yesterday, but I've refresehed it this morning and 5 calculated columns are now returning errors. 4 of them give the error "This expression refers to a AttributeHierarchy object named *ColumnName*, which has an error". The other calculated column returns the "multiple values where single value expected error". All 5 calculated columns refer to *ColumnName* which is the primary key/column of the same table.
There have been no changes to the dataset, the only thing that has happened is that the data has been refreshed. There are no errors or duplicates in *ColumnName* and all the data is in the right format etc, so I'm not sure why Power BI is saying it has an error.
Could anyone advise what might be causing this error?
Solved! Go to Solution.
The errors you're encountering could be due to several reasons. Here are some troubleshooting steps you can take to identify and resolve the issues:
Check Data Source:
Review Calculated Columns:
Check Data Model:
Refresh Metadata:
Clear Cache:
The errors you're encountering could be due to several reasons. Here are some troubleshooting steps you can take to identify and resolve the issues:
Check Data Source:
Review Calculated Columns:
Check Data Model:
Refresh Metadata:
Clear Cache:
Glad to know that was helpful. 🙂
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |