Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
I tried this and it worked perfectly. I like the Datamart feature but the bugs make it a bit tricky to use.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.