Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
One of my datasets is a MySQL database hosted on Azure. Power BI integrates nicely with MySQL and importing and using the data is no issue. However I wish to set up scheduled refresh once a day on this dataset. I am able to do this setting up a Gateway connection to my personal computer and this seems to work.
My solution so far looks to be using a VM in Azure with a static public IP to serve as this gateway. Which seems uncomfortably complicated and expensive..
Does anyone know of a more elegant solution?
Thanks,
Anders
Hi @Anonymous ,
Did you mean you cannot choose gateway for your dataset here? Please make sure your gateway is running and restart it to check again, or you can update it to try later.
Hi @Anonymous ,
Has your issue been solved? If so kindly mark my answer as a solution to close the case. Thanks in advance. Any other question, feel free to let me know please.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.