Forum Discussion

N_R_000's avatar
N_R_000
Helper I
5 years ago
Solved

Remove dataset in BI Desktop when using DirectQuery (Dec 2020 release)

I've been building reports using published datasets as my data source since the Dec 2020 release, but I'm now struggling to remove a dataset from a desktop build that I no longer need in the report; ...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi N_R_000 ,

     

    In the latest version, you can delete DirectQuery connections to Power BI datasets and Azure Analysis Services. To do so, go to the Data Source Settings dialog, which you can find in the dropdown for “Transform data”.

     

    In the Data source settings dialog, right click on the DirectQuery connection you’d like to delete:

     

    Please note that this does not reverse the action of adding a local model. This action deletes the DirectQuery connection, and all the tables and fields associated with that connection.

     

     

    Reference: Power BI February 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

parry2k's avatar
parry2k
Super User
5 years ago

N_R_000 I think at this point you cannot delete dataset2 and I'm sure this is going to improve in future releases.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡