cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Re: Cannot Delete Query/Parameter/Table

Hi. 

 

I think i might have found the solution to this one. It's silly

Home -> Manage Parameters

 

See if you can find the sample beeing referenced there. Delete it. 

That worked for me atleast 🙂 

rajendran Super Contributor
Super Contributor

Re: Cannot Delete Query/Parameter/Table

Hi @Anonymous

 

Good that you have fixed this issue. If you can post the snapshot of that Manage parameters page here, that will help ofther people who are looking for solution for this issue.

 

Thanks

Raj

ACN-Tiziano Frequent Visitor
Frequent Visitor

Re: Cannot Delete Query/Parameter/Table

Hi Christer, the problem we have is that the referenced paramater is not showing up on the "Manage Parameters" list:

 

Manage Parameters.jpgimage.png

nmck86 Member
Member

Re: Cannot Delete Query/Parameter/Table

@ACN-TizianoI am having the same problem did you get lucky and find a solution?
SBuri Member
Member

Re: Cannot Delete Query/Parameter/Table

Thanks for sharing Christr, this did not fix the issue for me. I have no parameters, still have something being referenced.

gaccardo-slb Frequent Visitor
Frequent Visitor

Re: Cannot Delete Query/Parameter/Table

I have the problem also.  "Sample File Parameter2 (2)" is supposedly referencing a query that I didn't created, but there is no such parameter and not one single shred of Power Query code references the query or the parameter.

 

The problem is the result of using some of the transformations available on the toolbar to filter the data.  These transformations created multiple folders of queries, some of which could be deleted, and some of which can't.  It is absolutely a bug somewhere in Power BI.

StanleyBlack Frequent Visitor
Frequent Visitor

Re: 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.

gaccardo-slb Frequent Visitor
Frequent Visitor

Re: 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.

K960154 New Member
New Member

Re: Cannot Delete Query/Parameter/Table

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.

contents of pbix file

 

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....

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors