Forum Discussion
Scheduled Refresh failure (Sharepoint)
Hi, I need some help with the issue below:
My dataset use both Gateway and Sharepoint (excel file) as datasource
On their own, both the Gateway data and Sharepoint refresh just fine with Scheduled refresh
However when used together in one dataset, i keep getting failure message from scheduled refresh
SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send.
Manual refresh work just fine with Desktop
2 Replies
- ibarrau
Super User
Hi. The thing is that when you are using both types of sources, onpremise and cloud, you need to specify the gateway that it shouldn't check all sources. Go to Gateway Settings and check the specific one you are using. Then check the following option:
That will let you have both sources.
You can read more about those gateway settings here: https://blog.ladataweb.com.ar/post/647097339965734912/powerbigateway-opciones-de-interés-en-puerta-de
I hope that helps,
