Forum Discussion
Gateway Refresh Error SharePoint: Request failed
We raised a ticket to Microsoft and comfirms it is due to set up of gateway. When no mash of data is done, the access of to sharepoint route via "Online", hence by default there is access. However in case of mash up data, access to sharepoint route via gateway, hence gateway must have access to both sharepoint and database. This is confirmed when we try to create a pbi data connection to sharepoint, it could not go through. This particular gateway was set up outside of the organisation network unlike the other 2.
Nope, not working. I created a 1 DB+1 sharepoint test file with reduced rows. Created a new dataset use merge as new, and still fails.
Logically if this is the cause, it should not only happen to 1 out of 3 gateways.
Please try creating 2 saperate Dataflwo (1 for DB and 1 for SharePoint)
then use as source in your Dataset to perform merge.