Forum Discussion
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...
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.)
