The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I am connecting to a MySQL database from Power BI
It appears that I need a gateway to enable automatic refresh?
If so, do I need a dedicated PC to run this gateway? Is there no other way of automating the refresh process ?
Kind regards
Solved! Go to Solution.
Hi @JHob
If you are connecting to a SQL Server that hosted in Azure VM but not Azure SQL database. For the former, gateway is required, you should install gateway on the same machine, then add SQL Server data source within the gateway.
For Azure SQL database, gateway is not required.
Hi @JHob
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!
Hi @JHob
Gateway is needed when your data source is on-premises, please refer to the detailed documents for refreshing data from SQL server:
https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql
Many thanks for your tutorial
Apologies, I am still trying to get my mind around gateways so my questions may seem a little obvious.
The MySQL database is not on our premises. A connection to it has been made available to us by a supplier and we have been give the IP address, database name and login. Is this then still classified as an on premises database ? Is this effectively then not in the cloud? Do we still need the gateway?
Kind regards
Hi @JHob
If you are connecting to a SQL Server that hosted in Azure VM but not Azure SQL database. For the former, gateway is required, you should install gateway on the same machine, then add SQL Server data source within the gateway.
For Azure SQL database, gateway is not required.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
42 | |
24 | |
23 | |
14 |