Excel Query Connection Error - No Query associated > not possible to remove the connection to a deleted query

[Syndicate_Admin]

Dear, 

Within Excel view I deleted a query but it seems that the connection to this query has not been properly removed. Something stay in the Existing Connection and I can' removed it completely. 

Then I constantly get the following error message when I do a refresh all.

Can you help me to solve this issue without having to rebuild a fully new excel file.

"The connection 'xxxx' has no query associated with it. Consider deleting it."

I checked the Existing Connections and indeed I can see this connection, but I can't Edit or Delete it.

When I double click on it, the Import Date bow opens but whatever the choice, no data is loaded.

[v-stephen-msft]

Hi @Sebastien13 ,

You may change or remove the authentication through the below document.

Authentication with a data source - Power Query | Microsoft Learn

When your authentication is removed, you lose your connection.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.