Hi Team,We are unable to connect MySQL from powerpivot 2012 for excel 64 bit .Server : windows Server 2008R2Excel : 2013 64 bit / powerpivot 2012MySQL : 5.2ODBC : 5.1 /64 bitI 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.
Operating System Language
Steps to Reproduce