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 online. Basically we had 2 problems when we want to use that databases.
The databases we have to use, are stored in 2 different services, which are:
1. a MySQL database hosted in a VPS offered by Hosting with Cpanel, and
2. a MySQL database hosted in Amazon RDS
Here I explain this problems:
1. We need to connect PowerBI Desktop with data stored in a MySQL database, but the Hosting (Hostgator) blocks any IP Address that tries to connect to the database. The hosting offer us a whitelist where we register all the IP Address we want to authorize, but when I try to register my public IP, PowerBI recognizes the tables and views inside database, but when he tries to obtain data, shows an connection error that says the service is not available.
How do I connect with that database? Do will I have to register the Microsoft Services IP Address in that Whitelist?
2. We connect to a database hosted in Amazon RDS successfully, due to that instance doesn't have IP blacklists, but the data when the report is online is not in realtime.
During our investigation, we found that PowerBI doesn't compatible with Direct Query when we use MySQL database, but aso I read about a service I think it called PowerBi Gateway or something like that.
Our customers needs to view the charts and information in realtime in a Dashboard that we provide to them, in a website that we developed.
How we do that the reports show the data in realtime?
Best regards from Chile.
