Forum Discussion

PizzaB260's avatar
PizzaB260
Copper Contributor
Aug 24, 2022

Power Query Warning: External Data Connections have been disabled

Hi,

 

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!

 

  • John_Mosher's avatar
    John_Mosher
    Copper Contributor
    This exactly describes my situation. Almost 11 months and 1071 views, does no one have a solution?

Resources