Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We want to connect a MySQL Database in Power BI Pro to refresh the data automaticly.
When we connect the MySQL Database in Power BI Desktop as data source, everything works fine.
After we import the pbix file (including datasets, reports etc.) into PowerBi Pro, the dataset and reports will be displayed correctly but its not possible to refresh the data from the data source.
In the dataset settings, we can edit the mysql credentials. The host and database values are already filled by default.
We just need authenticate, so add user and password. After we click "connect" it will load indefinitely. We do not get a connection error. We tried it with different databases on different servers, with and without ssl required, we are sure that our firewall is not blocking the connection. Also, we tried to connect a test mysql database with just a simple table of 10 rows and few columns with no foreign keys etc. and a simple table report in power bi, but we got the same endless loading result when connecting MySQL database in Power Bi Pro.
When I configure a on-premises data gateway with the MySQL connection, it works.
But it's not an optimal way for us because the connection is tied to my local machine and others in the team who have access to the reports can't refresh the data and automatic refresh wouldn't work either.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.