Online Information

Dear Members,

I write because I want to set up data which it's online. My databases are in MySQL databases.

Besides the API connection, What is the best way to connect data from PowerBI Desktop?

I want to shape the data in Power BI Desktop first. I have tryed Power BI personal connector for a few days but don't work well with mysql databases. The automated connection doesn't work, after validating the credentials and having the ok of Power BI Online. I would like to connect by OneDrive, but if I do so I miss the data shaping from Power BI Desktop.

I'm not worry about to download the databases in to a CSV and after uploading to Power BI, but I need a redudant service that can be trustable to get the data every day from the server.

I have this ideas but I'm not certanly sure about them:

Ideas for automatic Update:

1. If I have Azure SQL I can do data shapping and modelling in Power BI Desktop. After this I can upload the report, and schedule updates directly to the databases.
2. Personal Gateway + CSV: Download every day / every hour (depends) a CSV of all databases. Personal gateway review the data in a daily basis. My fear here if the Personal Gateway sometimes close itself without reason or have very strange errors like "Internal Error".
3. OneDrive: Is there a way to get Onedirve from PowerBI Desktop?.
4. API Development: Is there some API development for mysql databases?.

* I need Power BI Desktop for manage relationship, create measure, and specific fields. Power BI Online is not enough powerfull to achieve this type of tasks.