Forum Discussion
On Premises Gateway can't access the on-premises data source
I have been creating dataset combining data from Teradata, and files stored on SharePoint and OneDrive. For some of these datasets, the scheduled refresh via the On Premises gateway (which is currently running on my PC) works fine, but for others it worked fine for a week or so on scheduled refresh, but then started to always fail with the message;
Last refresh failed: Thu Mar 08 2018 15:52:05 GMT+0000 (GMT Standard Time)
We reached the data gateway, but the gateway can't access the on-premises data source.Hide details
| Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
| Activity ID: | ae324436-bb45-78da-f1a0-a9a742ad95b0 |
| Request ID: | 88a5239b-51aa-3771-b9b6-9520bc6afc1c |
| Time: | 2018-03-08 15:52:05Z |
I'm using Power BI Desktop Version: 2.55.5010.641 32-bit and 64 bit (February 2018)
On-Premises gateway is 14.16.6614.5
I've tried re-creating the datasets from scratch, and at first everything works fine, but as soon as I add substantial data from SharePoint or OneDrive, the update fails.
I can refresh the data using the Desktop without problem.
22 Replies
v-jiascu-msftMicrosoft Employee
Hi 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/
- jeffshieldsdev
Solution Sage
Same intermittent error for me. Also using Teradata.
I'm aliasing my Teradata server using the HOSTS file, but all gateways in my cluster have the same HOSTS file.
roselilly23Advocate V
I was getting the same error message when trying to mashup data from azure sql datawarehouse with on prem sql server.
To solve my issue I had to:
- Update our enterprise gateway to the latest version
- Check the box "Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster".
- Ensure the privacy settings for both datasources was set to "Organizational"
Prior to ticking the box it was saying my gateway was not set up properly and was suggesting that I add the azure sql datawarehouse to the gateway (which you can't do).
- GilbertQHi there
That is 100% correct because one is cloud and the other source is on-prem.
You have to make sure that the Gateway is configured to be able to access both sources before you can configure the scheduled refresh.
