Forum Discussion

rootsmusic's avatar
rootsmusic
Brass Contributor
Oct 28, 2021
Solved

can't delete "connection only" query from Power Pivot

In Excel for Microsoft 365, I initially added a query to my data model.  Then I changed it to load as "connection only".  But it's still in Power Pivot, which doesn't let me delete it.  How do I dele...
BI & Data Analysis
  • rootsmusic's avatar
    rootsmusic
    Oct 28, 2021

    Yea_SoI was trying to delete the query from the data model (Power Pivot), but keep it as "connection only" in Power Query. I finally did so by renaming the "connection only" query and disconnecting its relationships. (So it seems to be a bug in Power Pivot when trying to delete a query that has active relationships.)

Yea_So's avatar
Yea_So
Bronze Contributor
Oct 28, 2021

rootsmusic 

 

To clarify,

are you trying to delete a query from the query navigator?

or 

are you trying to delete a queried data set from the data model?

rootsmusic's avatar
rootsmusic
Brass Contributor
Oct 28, 2021

Yea_SoI was trying to delete the query from the data model (Power Pivot), but keep it as "connection only" in Power Query. I finally did so by renaming the "connection only" query and disconnecting its relationships. (So it seems to be a bug in Power Pivot when trying to delete a query that has active relationships.)

Resources