Home Dashboard Directory Help
Search

ODBC connection from Powerpivot connecting to MySQL Error by Rakesh M J


Status: 

Active


3
0
Sign in
to vote
Type: Bug
ID: 777703
Opened: 1/28/2013 12:39:50 PM
Access Restriction: Public
2
Workaround(s)
view
1
User(s) can reproduce this bug

Description

Hi Team,
We are unable to connect MySQL from powerpivot 2012 for excel 64 bit .

Server : windows Server 2008R2
Excel : 2013 64 bit / powerpivot 2012
MySQL : 5.2
ODBC : 5.1 /64 bit

I have enabled SQL Mode + ANSI standards in MySQL Server and get an error stating error in SQL syntax. I can preview the data in the query window but cannot use it in powerpivot.

I had the same issue in Analysis services 2012 with 32 bit connector. SSIS works fine.
Details
Sign in to post a comment.
Posted by Wouter1231 on 2/14/2013 at 6:32 AM
I think this is the same as this bug: http://connect.microsoft.com/SQLServer/feedback/details/766172/error-on-powerpivot-table-import-wizard-when-getting-external-data#tabs
Sign in to post a workaround.
Posted by An M on 5/2/2013 at 8:19 AM
Using the 3.5 version didn't solve the issue for me. Is it maybe because my MySql Server is 5.x ?
Posted by Wouter1231 on 2/14/2013 at 6:50 AM
Installing MySQL ODBC driver version 3.51.30 solved it.
As suggested here: http://www.joyofdata.de/blog/how-to-set-up-powerpivot-and-make-it-talk-to-mysql/#comment-51