Forum Discussion
Unable to delete measures after changing data source location
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 🙂
Doesn't work. Can't even right click. When I right click, it pops up the error message above.
Have you tried deleting them with Tabular Editor?
Pat
That's actually a good idea, unfortunately the issue is in the PBI report that is conected to a PBI dataset, in which case the Tabular editor doesn't work. It works on the dataset report itself, however there is no issue there, its only on the visual report that connects to PBI dataset.
sorry, but to confirm are you trying to delete these measures out of a PBIX that has a live connection to a published dataset?
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 🙂