How to delete data in a folder from the Power BI Desktop ?

[Anonymous]

Hello Experts,

Could someone help me on deleting folders in query editor of powerbi desktop? There's no option to remove or delete except clear permission. Is there a way to remove? Coz I will no longer use it.

Please advise.

Thanks

[Anonymous]

Hello,

Good day!

This issue has been posted in ideas awaiting to be approved.

Thanks

[parry2k]

@Anonymous send the link of ideas so that I can vote and encourage others to vote as well. 

[Anonymous]

Hello Parry,

I don't have that radio button. What choices that I have is the data source in current file and the global permission. If I choose the data source in current file all folders/ data files are shown but there is no remove options under edit permission or clear permission. So probably this feature is not yet available.

Thanks

[Anonymous]

Hi @Anonymous,

If you want to get rid of a data source, I think it will work to do what @v-juanli-msft said - 

Go to the Power Query Editor, and remove the unnecessary queries from the Queries Pane. That should remove the associated data sources.

Regards,

Nathan Peterson

[Anonymous]

Hello Natel,

The once that he mentioned is not applicable as those data in the source file settings are no longer connected in the queries. What I want is to just get rid with that first two folders. Take them out in the queries:

Thanks

[Anonymous]

@Anonymous , I have verified that I'm not able to delete a reference to a folder either. I think you could modify it to some non-existing path, if you want to protect the folder. I don't know what else to do.

[Anonymous]

It's okay Natel. Maybe it's not yet in their features. Thanks for all your suggestions. I appreciate all of those.

[parry2k]

@Anonymous I would recommend to put this as an idea on ideas forum so that if it get voted, it can be available in the future.

[Anonymous]

This is a good idea Parry. I'll submit then.

Thanks a lot for all your time in taking my queries. Have a good day!

[v-juanli-msft]

Hi @Anonymous 

I connect to a folder with Power BI Desktop, then i get a table with information of the folder.

Would you like to delete any column or all columns from this table?

If so, i could delete by "delete columns"

If you connect to several folders with Power BI, then you want to delete one folder, you could right click on the table name to select "delete".

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,

Good day!

I'd like to clarify my question, my apology. What I mean is I want to delete the data source as I no longer use it in the dashboard. I need to delete the first two sources as shown below. I appreciate your help.

[parry2k]

@Anonymous 

- Click global permission

- right click on connection you want to remove

- click edit permission

- on popup dialog, click delete,

- click ok, you will get warning message. click ok

it will remove the connection.

[Anonymous]

Hello

@parry2k,  I've tried but when I choose the Global permission the sources that I want to delete doesn't show. Here is the snippet

[parry2k]

@Anonymous in my instructions i mentioned right click on the connection, did you tried that. here it is again

- Click global permission

- right click on connection you want to remove

- click edit permission

- on popup dialog, click delete,

- click ok, you will get warning message. click ok

[Anonymous]

Hi Parry,

Yes, I did and I screenshot the view when I choose the global permission. All folders are gone and replaced with this link  'http://www.imdb.com/chart/top"

So I could not delete them.

Thanks

[parry2k]

@Anonymous interesting didn't noticed that. can you try the same process on "connection in same file"

[Anonymous]

Hello Parry,

Not so sure. I think I will just put them in there instead rather than deleting.

Thanks for all your help I appreciate it much. Hope you don't bother much on all my queries.

[parry2k]

@Anonymous no worries but i'm concerned that issue is not resolved. I was telling you to selection another radio button next to "global permission" and run thru the steps which I mentioned and see if it works. Did you tried it? If not, can you give it a try?