Forum Discussion
Unable to delete measures after changing data source location
Hi everyone!
I am facing an annoying bug/issue.
Previously I had developed a PBI report, with some measures here and there.
At one point, it was necessary to switch from the testing dataset to the PBI dataset, but not all the measures were aligned.
Now I am unable to delete some of the measures that do not work anymore (See screenshot).
When I press on the 'three dots' for more options, it simply displays "Something went wrong" error.
What to do? Thansk!!!
Pictures:
Measures with errors. Cannot be opened, viewed, edited, deleted.
Error message:
Yes exactly!
And I did find a solution just a couple of minutes ago.It might be a bug inside Power BI or just my own low level of brain capacity hah
The scenario was that the PBI report had some measures with the same name as the new Live PBI dataset that I connected to. This led to having measures with duplicate names and PBI doesn't like that, which resulted in one of those measures to be 'broken' as on the picture.
Even though I was not able to delete the broken measures directly, as it simply gave me an error, I was still able to rename the broken measures and then delete them 🙂
10 Replies
Have you tried deleting them with Tabular Editor?
Pat
I would suggest this actually is a bug. I've had this exact same issue. In the past, I've been able to right click and "delete from model", but that no longer works consistently (sometimes it does, usually it doesn't). When it doesn't work, there is no error. It just doesn't do anything.
Renaming and then deleting is not a good solution. Here is why:
My use case: I have a live connection to SSAS tabular. I create a custom measure within the PBIX file named "Widget Count", and build out a number of pages of content using this custom measure. It's such a useful measure, I have it built into the SSAS tabular model itself with the same name. So when I delete the custom measure in my file, all my reports will already work because they'll find the name. If I have to rename before I delete, I'll need to update every view with the new measure, which can be a lot of work, especially when you've formatted the view with certain colors/styles/conditional formats/etc.
The renaming option is only good if the measure in your file has a different intent/definition than the duplicate that was created.
I'm using this version:
Microsoft Power BI Desktop (Optimized for Power BI Report Server - May 2022)
