Forum Discussion

Jean-Claude Allenbach

Copper Contributor

Mar 17, 2017

Powerpivot for Excel 2013 compatibility with SQL Server

Is PowerPivot for Excel 2013 32 bit compatible with SQL Server 2014 SP1 Enterprise 64 bit ?

BI & Data Analytics

Requests

Jean-Claude Allenbach

Copper Contributor

Mar 23, 2017

I have some problem to connect PowerPivot for Excel 2013 32 bit and SQL Server 2014 SP1 Enterprise 64 bit, and I wasn't sure if this configuration is OK, because I find only in MS compatibility table, compatibility from SQL Server 2008 to 2012, nothing about 2014.

Wyn Hopkins

MVP

Mar 24, 2017

are you connecting using Power Query (Get&Transform) or direct in Power Pivot?