Forum Discussion
Relocated Measures in my Dataset
I have a report connected to a dataset. In the report I have many visuals that refer to the Measure 'mdw CaseFact'[Total Recordable Incident Frequency].
In the dataset, I moved my measure "Total Recordable Incident Frequency" from the 'mdw CaseFact' table to a different table. When I refresh the report that it is connected to the dataset it cannot find the Measure as it still expects it to be in the 'mdw CaseFact' table. I would have expected that by refreshing the report, it would have updated the location of the measures in the model and that I would perhaps need to repoint the visuals to the new locations. But it just seems unable to find the measure in the other table.
Any ideas for a quick fix?
I found a solution, but it's not great...
Using Tabular Editor I was able to delete the 'Total Recordable Incident Frequency' Measure in the Thin report. Once you save the report you can then refresh the dataset. All of the visuals that were pointing at the deleted measure are now obviously broke. You then need to go through each individual measure and repoint it to the new location.
3 Replies
- amitchandak
Super User
Anonymous , based on what I got.
Open power query , right-click on the table, open advance editor. Check for column list n first few lines and carefully remove the column.
refer to my video on the same topic
https://www.youtube.com/watch?v=h0yLtceT0i4
keep a backup of file
I found a solution, but it's not great...
Using Tabular Editor I was able to delete the 'Total Recordable Incident Frequency' Measure in the Thin report. Once you save the report you can then refresh the dataset. All of the visuals that were pointing at the deleted measure are now obviously broke. You then need to go through each individual measure and repoint it to the new location.
