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.
This could be because of SharePoint request limit
Can you answer below to help better
1. Are you having multiple tables connecting to SharePoint
2. Are you merging tables in same dataset
3. What is the size of file/data that you are pulling from SharePoint
4. As this is SharePoint online, why are you using gateway
1. Are you having multiple tables connecting to SharePoint
-2 table connect to 2-3 tabs in sharepoint.
2. Are you merging tables in same dataset
-Have some joins, append, relationships happen to the same dataset.
3. What is the size of file/data that you are pulling from SharePoint
-Very small, 1000 rows
4. As this is SharePoint online, why are you using gateway
-I have main data source connect to database.
Thing i dont understand is that it only happen to 1 out of 3 gateway connection.
This happends because suring merge,append the Power Query send multiple request to SharePoint thus it will be hitting SharePoint concurrent request limit and slow down the refresh
Please follow below and see the difference1. Create saperate dataflow for database and SharePoint (Just inital load, no transformation)
2. Use above dataflow as source for your datasetNope, 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.