Initialization of the data source failed

%3CLINGO-SUB%20id%3D%22lingo-sub-1540329%22%20slang%3D%22en-US%22%3EInitialization%20of%20the%20data%20source%20failed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540329%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20all%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20Excel%202016%2C%20we%20built%20a%20data%20model%20with%20Power%20Pivot%20in%20our%20dashboard%2C%20and%20then%20shared%20to%20our%20users%2C%20who%20may%20be%20using%20Excel%202010%2F2013%2F2016.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhen%20they%20want%20to%20interact%20with%20a%20PivotTable%20that%20uses%20the%20workbook%20Data%20Model%20as%20a%20data%20source%20in%20the%20dashboard%2C%20the%20error%20%22Initialization%20of%20the%20data%20source%20failed%E2%80%9D%20will%20happen.%20And%20we%20found%20below%20link%20to%20know%20about%20this%20error%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fpower-pivot-error-initialization-of-the-data-source-failed-55d6b559-3124-4583-85fb-deb2fa1c098b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fpower-pivot-error-initialization-of-the-data-source-failed-55d6b559-3124-4583-85fb-deb2fa1c098b%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIt%20mentions%20that%20%E2%80%9CTo%20work%20around%20this%20error%2C%20upgrade%20to%20Excel%202013%2C%20Office%20Professional%20Plus%20edition.%20Data%20Models%20created%20in%20Excel%202013%20will%20run%20only%20in%20workbooks%20that%20are%20also%20opened%20in%20Excel%202013.%3C%2FSPAN%3E%E2%80%9D%3C%2FP%3E%3CP%3E%3CSPAN%3EMy%20question%20is%20that%20our%20Excel%20is%20built%20in%202016%20version%2C%20so%20do%20our%20users%20also%20need%20to%20upgrade%20to%20Excel%202016%3F%20Or%20is%20the%20Excel%202013%20enough%20for%20them%20to%20run%20our%20data%20model%20in%20the%20dashboard%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1540329%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi all,

 

In Excel 2016, we built a data model with Power Pivot in our dashboard, and then shared to our users, who may be using Excel 2010/2013/2016.

 

When they want to interact with a PivotTable that uses the workbook Data Model as a data source in the dashboard, the error "Initialization of the data source failed” will happen. And we found below link to know about this error:

 

https://support.microsoft.com/en-us/office/power-pivot-error-initialization-of-the-data-source-faile...

 

It mentions that “To work around this error, upgrade to Excel 2013, Office Professional Plus edition. Data Models created in Excel 2013 will run only in workbooks that are also opened in Excel 2013.

My question is that our Excel is built in 2016 version, so do our users also need to upgrade to Excel 2016? Or is the Excel 2013 enough for them to run our data model in the dashboard?

 

Thank you!

0 Replies