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.
Hello,
We are currently on the Power BI PRO (trial account).
We managed to configured the On-premise Gateway and the connection to our company MySQL database.
However, the gateway is not available when we were trying to Schedule Refresh (see image below)
Please advise. Many thanks.
Solved! Go to Solution.
There might be few reasons why you're not seeing the gateway:
1- The connection information within Power BI desktop doesn’t match the data source. The Server name and database name need to be the same for Power BI to make a match.
2- You have an online scenario in your dataset, it needs to be added as well
3- You're using oAuth with your datasource, which is not supported thru the gateway
and also you need to create a new data source of your data base and include the users as well....
Do you need to include all the users? Or just the Admin?
There might be few reasons why you're not seeing the gateway:
1- The connection information within Power BI desktop doesn’t match the data source. The Server name and database name need to be the same for Power BI to make a match.
2- You have an online scenario in your dataset, it needs to be added as well
3- You're using oAuth with your datasource, which is not supported thru the gateway
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.