cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qubit813
Post Patron
Post Patron

does SharePoint Online use gateway even when not configured?

I have a report that sources and blends data from an on-prem SQL Server data warehouse and Excel files that reside in SharePoint Online.  I have not added the SharePoint site to the gateway.

 

I have been experiencing scheduled refresh failures for the past few days.  The gateway logs share errors like:

SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send.

 

Why is the gateway showing anything about SharePoint, given I haven't added the site to the gateway?

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

Hi @qubit813 

 

If you are combining data from On-Prem and SharePoint online you will need to use the gateway for the refresh to work successfully.

 

Here are details on how to configure this in the Gateway: Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User II
Super User II

Hi @qubit813 

 

If you are combining data from On-Prem and SharePoint online you will need to use the gateway for the refresh to work successfully.

 

Here are details on how to configure this in the Gateway: Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

@GilbertQ 

 

I'm confused by the MS documentation on this scenario (in the link you provided).  Under Gateway Cluster Settings, I have activated the 'Allow user's cloud data sources to refresh through this gateway cluster...' option.  However, in the dataset itself, there is also an option for adding the SharePoint Online source to the gateway.  I have not added this source to the gateway.  Does this still imply that the PBI service is calling SharePoint Online through the gateway?

@qubit813 - when you merge data from On-Prem and SharePoint online the merge operation happen on your Gateway only thus you have to enable "Allow user's cloud data sources to refresh through this gateway cluster" option in Gateway setting.

 

If you want to SharePoint process not to run on gateway follow below steps

 

1. Create dataflow for On premise data using gateway connection

2. In your dataset replace onpremise source with Dataflow

 

Now your merge opration will be perfoemed online and you will not be requing to enable "Allow user's cloud data sources to refresh through this gateway cluster" option anymore.

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates