Forum Discussion
Cannot Delete Query/Parameter/Table
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.