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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.