MySQL connector to Datamart Issue

[Bebo]

I have a MySQL database that I have been trying to use with datamart. I use the Mysql databae connector and get the following error: Invalid credentials. (Session ID: 55381723-87d8-4339-9e53-685ffc025b67, Region: us). I have conneccted this same database to MySQL Workbench using the same credentials and evrything connects fine. 

Any suggestions?

[otravers · Accepted solution]

Datamarts are very new and fairly buggy at the moment, try doing your data ingestion upstream in a dataflow, then use that dataflow as your source for the datamart. Either way you'll need to use the Power BI data gateway to connect to MySQL, as well as the MySQL connector:

https://docs.microsoft.com/en-us/power-query/connectors/mysqldatabase

In other words, being able to connect using MySQL Workbench doesn't establish that you've met the requirements to connect from either Power BI Desktop or the Power BI service.

[Bebo]

I tried this and it worked perfectly. I like the Datamart feature but the bugs make it a bit tricky to use.