Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.