CODEWITHSUNDEEP
powerpivotpowerqueryexcel-2016
RicoS321
RicoS321

Reputation: 23

Initialization of the data source failed - Excel 2016

I'm trying to refresh a query in Excel 2016 (new install) and I get the above error. I've looked around, the problem seems quite common, but none of the answers seem to fit my issue.

In Excel, I have a couple of tabs of data in Excel tables. I use Get & Transform to import these tables into Power Query from where I generate 4 further tables of data, which are uploaded to the Data Model. I then create 3 relationships and generate 3 pivot tables with a single slicer to operate the tables.

When I come out of Excel and go back in and select "Refresh All", this is when I get the error:

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. If you see this message again, create a new data source to connect to the DB

The data source is the excel workbook. I tried re-creating the Power Query queries etc, but to no avail.

Repair on Power Pivot also didn't work.

Given it's a new install of 2016, which comes with Power Query and Pivot as standard, I'm not sure where to try next.

Any help much appreciated.

Upvotes: 1

Views: 10199

Answers (1)

David Rogers
David Rogers

Reputation: 2653

I ran a repair on my installed version of Excel 2010, and that seems to solve the issue for me, I've seen sometimes when the user has multiple versions of excel installed library references can get broken, resulting in this error.

Upvotes: -1

Related Questions