Using Power Query for Excel, I have a dataset that connects to a folder full of Excel files. Everything seems to work fine until I try to filter in the resulting query. It looks fine in the editor, but when I try to load it to a table I get the message: "Data could not be retrieved from the database. Check the database server or contact your database administrator. Make sure the external database is available, then try the operation again." As long as I don't filter the result in the query itself it loads to an Excel table. Any thoughts?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Issues with connecting to folder in Power Query for Excel
- Thread starter smdavid83
- Start date
