Solved Power Pivot and MySql (1 Viewer)

Etxezarreta

Member
Local time
Today, 15:05
Joined
Apr 13, 2020
Messages
175
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
1611869793307.png
 

Etxezarreta

Member
Local time
Today, 15:05
Joined
Apr 13, 2020
Messages
175
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.
 

Users who are viewing this thread

Top Bottom