Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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,