Relocated Measures in my Dataset

[Anonymous]

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?

[Anonymous · Accepted solution]

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.

[amitchandak]

@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

[Anonymous]

Hi Amit,

Thanks for the prompt reply, it's much appreciated.

To clarify,  the report that is failing to find the measure is a Thin report, the model exists on the Power BI dataset.  There is no Query on the thin report to edit with Power Query.

Thanks,