Forum Discussion
Deleted fields in personalized visuals
Hey Anonymous , I found your topic, and noticed it did not have a solution, but I believe I found it.
First, why does this happen? Well for me this happened with measures that I created in the report file, after which I created a measure with an identical name in the dataset file (I use a powerBI file als my dataset, and another as my report).
This basically causes a duplicate measure to exist once you refresh your report file. For some reason, you cannot then delete this measure (this seems like a bug) and it will show up in any perspective that you create. Now you probably went a step further, and deleted the actual table from the model in your dataset file. This causes the whole table to disappear in both your report and dataset file. However, under water the report file wasn't able to remove the formerly duplicate measure from the report file, so it still exists, even though you cannot see it anywhere.
So what is the solution?
1. You will need to recreate a table (you can just use "enter data"for this) with the exact same name as your deleted table, in your dataset file.
2. You need to then upload that to powerbi, and refresh your report file so it now has that table in there too.
3. And what do you know, it also shows that invisible measure! You can now delete that measure, save your report file.
4. Then go back to your dataset file, and delete the table. You have now successfully removed the measure from the report file!
For measures that are duplicated, you should:
1. rename the measure in your dataset file temporarily.
2. Publish the dataset to the cloud.
3. Refresh your report file. You will see the warning symbol disappear.
4. Delete the measure from your report file, save
5. rename the measure in your dataset file back to the original, save.
Now it's fixed!