Forum Discussion
Cannot Delete Query/Parameter/Table
Has anyone heard anything more on this?
I've renamed mine for the time being so it is out of the way but it's frustrating that it can't be deleted as I have number of queries already and it's just occupying space.
Hi StanleyBlack ,
I have not heard anything on this issue. Because I have another issue (a relationship that disappears
every time I refreshed the data), I rebuilt the entire report by copying everything from the old/broken
report into a new one. With this method, I was able to get rid of the unused parameter, but Microsoft
has never offered a solution for simply deleting it. Based on what I hear at PUG meetings and what I see
from my own bug reports, I doubt Microsoft can keep up with the bugs being submitted.
well found the issue but don't know how to fix it. :(
Backup your pbix first (very important).
either rename the file from <name>.pbix -> <name>.zip or use a 3rd party filemanager tha can open zip files by content.
The file you want is called datamashup
this seems to be a part binary/part xml file listing items in the data model.
I found all the incorrect references listed in here. Although deleting them from the xml and importing the Datamashup back into the pbix file resulted in a corrupted file (as expected). Hence the backup requirement at step 1 :)
If anyone can work out how to edit the file cleanly. We may have a solution to this....
Make sure that you have no Calculated columns or Measures that reference the Param, If you deleted all of these and the Params, it should work.
I used Tabular editor from SQLBI, and saw I have 2 CC and 1 MX that referenced a para that had been deleted.
Once i deleted all trace and reference to the params, it worked and no longer showe dup in my Code,
PowerBi helper from RAd cad was also good to see the M code easily.
