Forum Discussion
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_MosherCopper ContributorThis exactly describes my situation. Almost 11 months and 1071 views, does no one have a solution?