Dec 2, 2020 · „Initialization of the data source failed. Check the database server or contact your database administrator. Make sure the external database is still available, and then try the operation again….

Oct 7, 2024 · How do I fix the Excel error initialization of the data source failed? 1. Download the latest updates for Excel 2. Map to the same drive on SharePoint 3. Reinstall the Power Query add-in 4. Clear the SharePoint List’s Permissions 5. …

Sep 19, 2024 · What we have found is that the connection string to the model appears to have a setting/variable which Microsoft have potentially removed. Below is the old connection string used across our various Excel files, which would output the above error. Removing the part in bold appears to fix the issue.

May 9, 2018 · Initial of the data source failed. Check the database server or contract your db admin. Make sure the external db is available and then try the operation again.

Oct 28, 2018 · Re: Initialization of data source failed error You're probably missing some software. The error is not Excel related but to the data you use and the source data.

You may receive the following error opening an Excel Worksheet with a linked Access Database. Initialization of the data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again.

Jul 1, 2014 · I've stumbled with this problem for some time. I have an Excel 2013 workbook that connects MySQL server and updates Power Pivot data model by using a VBA script. The db connection has been created with Power Query addin.

Jun 14, 2016 · I have been successfully running powerquery with Windows 10 and Excel 2016 (office 365) to get filtered data from one excel worksheet to another.

Jun 13, 2018 · “Initialization of the data source failed” error message can occur if you are opening a newer Data Model in an older version of the Power Pivot add-in. As an initial troubleshooting, we suggest performing a Safe Mode in your Excel 2016 application and see if …

Mar 28, 2016 · I get the following error: Initialization of the data source failed. Check the database server or contact your database administrator. Make sure the external database is still available, and then try the operation again.