Forum Discussion
On Premises Gateway can't access the on-premises data source
Microsoft EmployeeHi Anonymous,
Did you update the credentials in the settings of datasets? Can your computer access the outside sources? The error message seems clear.
Best Regards,
Dale
Yes, I always check the credentials, and the computer can access the on premise datasources and the web/cloud ones too. When I treid rebuilding the dataset from scratch and using the gateway to update the dataset periodically as I went, the scheduled update would work properly, updating numerous times using the personal mode gateway, and then will cease to function at all, even if I then remove some of the queries I have added. I have tried deleteing the dataset and re-publishing it.
- GilbertQ
Super User
hi Anonymous
Have you tried installing the On-Premise Data Gateway, but selecting the Enterprise Gateway Option to see if that works?
There has been a recent update where it now allows sources from On-Premise and Cloud
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-february-update-is-now-available/
I have been using both on-premises gateway, and the personal mode version and both with success until now. I have both running concurrently on my PC as we have not rolled this product out to the live/production environment.
I'm not sure what you mean by the enterprise version. Is this a third flavour?
Just to empahsise, I have many other datasets which are successuly updating/refreshing using either of my two gateways, combining data from Teradata and SharePoint. This latest datset also used to update perfectly well, but as we added more and more queries it suddenly broke, and will not revert to successful updating when we remove queries.
