Forum Discussion
power BI gateway connection issues
Hi PhilB,
On-premises gateway doesn’t work with online data sources currently, thus if you combine on-premises MySQL data source and online data source such as Google Analytics in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review, please vote it.To work around the issue in your scenario, you can use the personal gateway to schedule refresh for your dataset.
Thanks,
Lydia Zhang
Hi Anonymous
Thanks for the info it was very helpful. We definitely had a working (Connection test successful) data source in place and we had the data source privacy set to Public to help with any potential permissions issues.
Your sentence regarding multiple data sources probably holds the key. We have a Dataset which includes both MySQL Data and Google Analytics Data.
In the "Add Data sources" option on the Gateway there doesn't seem to be an option for analytics. In a mixed location dataset is it required to have all sources in the gateway?
Our main problem is that it looks like everything is set up correctly however when we go to schedule refresh we have no gateways available. If we click "Refresh now" it comes up with a personal gateway error even though we have no personal gateway set up
Hi PhilB,
On-premises gateway doesn’t work with online data sources currently, thus if you combine on-premises MySQL data source and online data source such as Google Analytics in a dataset, you are not able to use on-premises gateway to schedule refresh for the dataset. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review, please vote it.
To work around the issue in your scenario, you can use the personal gateway to schedule refresh for your dataset.
Thanks,
Lydia Zhang
Hi Anonymous,
That got it sorted. I can now connect to my data gateway. We had it set up as an enterprise gateway which we have changed to personal and it found it straight away. Both answers very useful.
Much appreciated Anonymous