Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

help with connect PowerBI with MySQL database

Hi there  I need your support due in my business, I had to connect PowerBI Desktop to MySQL Database for data analysis, with success. But the data isn't in real time when the report is published on...
Connect MYSQL
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , I am assuming you are able to connect to mysql on power bi desktop , if not then make sure you have installed latest driver 

https://dev.mysql.com/downloads/connector/net/

 

How do I connect with that database? Do will I have to register the Microsoft Services IP Address in that Whitelist?

 

This list is needed, when you are able to connect database directly in power bi service without on premise gateway. In case of on premise gateway; you have to give ip of the machine having on premise gateway  

 

ip list for web databases -https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls

 

On Premise gateway refer

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app