Power Query Warning: External Data Connections have been disabled

Copper Contributor



in the document I am currently working on, I have several tables which act as the sources for Power Query queries. All of these tables are included in the very file I am working on.

However, when I open the file, I get the warning, that external data connections have been disabled.


While I would like to keep external data sources disabled (I am only using the tables in the file via Excel.CurrentWorkbook()), I would expect all the "internal" data sources to be enabled. However non of my queries is executed until I enable external data sources.


Is it possible to enable internal data sources, while keeping external data sources disabled and how can I possible tell Excel how so distinguish between internal and external data sources?


Your input is highly appreciated!


1 Reply
This exactly describes my situation. Almost 11 months and 1071 views, does no one have a solution?