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.

Icey's avatar
Icey
Community Support
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.