Set up a dataflow using Sharepoint source, gateway unreachable on scheduled refresh (PC offline)

[olimilo]

I set up a dataflow using a Sharepoint folder as a source, however over the weekend, the scheduled refresh didn't push through because it kept raising a gateway unreachable error over the weekend (where my PC was turned off/disconnected from the internet):

Error
Error: Encountered user gateway exception: '[GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException'. RootActivityId = a827abac-bb38-4f13-acbe-39d73447ab54.Param1 = [GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException Request ID: 82744db9-eec5-4a24-9e96-7207a2cf8332.
Error: Encountered user gateway exception: 'A task was canceled. [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_CanceledError [ErrorShortName]=GatewayCancellationException/TaskCanceledException[HResult=-2146233029] [ExceptionErrorShortName]=GatewayCancellationException'. RootActivityId = a827abac-bb38-4f13-acbe-39d73447ab54.Param1 = A task was canceled. [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_CanceledError [ErrorShortName]=GatewayCancellationException/TaskCanceledException[HResult=-2146233029] [ExceptionErrorShortName]=GatewayCancellationException Request ID: 82744db9-eec5-4a24-9e96-7207a2cf8332.

I tried creating a new table from the same Sharepoint folder using an existing gateway and used both Anonymous and Windows as authentication mode, but I got invalid credentials on both attempts (I entered my credentials correctly).

My understanding is that since the source is a Sharepoint folder, there is no need to keep my PC online. Is this not the case? What can I do to fix this?

[Anonymous · Accepted solution]

Hi  @olimilo ,

There is no need to add a SharePoint data source in the gateway because the Power BI service can directly connect to the SharePoint cloud service. According to the test, although it displays an X next to the SharePoint data source (because I did not add it to the gateway), I can still refresh the data stream correctly.

Data source credentials added to the gateway are managed on the manage gateway page, while data source credentials not added to the gateway are managed on the data flow settings page (the data source credentials section you see).

Have you not have the checkbox to allow cloud sources selected.

https://community.powerbi.com/t5/Service/Power-BI-Dataflow-Error-when-adding-to-gateway/td-p/1096450

Or you try to change it to none:

https://debbiesmspowerbiazureblog.home.blog/2020/09/14/power-bi-how-to-connect-up-to-a-sharepoint-fo...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[StefanoGrimaldi]

hey, 

when you configure the source you are asked to specify a gateway as conection point to the internet that its used to connect to the source, if you left the gateway option blank it should connect directly to the sharepoint source if the credentials are ok, this way you arent sending the update request via the gateway that its what happend when you select a gateway for that source.