ODBC connection from Powerpivot connecting to MySQL Error

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

Active

Type:	Bug
ID:	777703
Opened:	1/28/2013 12:39:50 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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 (expand)

English

SQL Server 2008 R2

Developer Tools (SSDT, BIDS, etc.)

Windows Server 2008 R2 Enterprise

English

1. Download and install MySQL server
http://dev.mysql.com/downloads/installer/

2. Download and install 64 bit ODBC connector for windows
http://dev.mysql.com/downloads/connector/odbc/5.1.html#downloads

3. Download and install the Office 2013

4.Create and ODBC user DSN using the installed MySQL 64 bit driver

5. Connect to MySQL in powerpivot using other datasources

SQL Syntax error even after enabling the SQL mode and ANSI style syntax in MySQL . SSIS is able to talk and import data.

Should be able to import the data

X64

Hyper-V (On-Premise)

0 attachments

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

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