Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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

Need Help

18 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        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's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello,

     

    Good day!

     

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

     

    Thanks

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

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