Solved Power Pivot and MySql

[Etxezarreta]

Hello everyone,
I want to download datas from a MySql db into Powerpivot using ODBC, and more precisely the connexion string generator included in PowerPivot.
ODBC drivers have been downloaded, but I do not succeed.
I know that there is another way, starting from MySql, and creating a new connexion, but I am a rookie at using MySql.
Thank you for sharing your experience and advice.
Etxe.


o

 

[Etxezarreta]

Solved the problem:
need to create a connection from the ODBC connection wizard (MySql 8.0 ANSI drivers), then you will find it in the Powerpivot conenction wizard.