Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have made a report using an existing Power Bi dataset, and a single file from sharepoint. When i refresh in Power Bi desktop everything works perfectly, but when i refresh the published report something goes wrong, and a get a COM error in my DAX calculated columns.
(Partnumber is the name of a table in the other power bi dataset).
The weird thing is that it does not return an error in the output of the calculated column, but when i try to use the calculated column in a visual i get this error.
I can show data directly from the power bi dataset without issue.
@skanord , Open power query and check, one of the columns has an issue.
You mean i shoul open the power query in the other report i am retrieving the data set from?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |