Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
burtta
Advocate I
Advocate I

Sharepoint Gateway

When I review the Dataset Settings -> Gateway Connections, it shows the gateway or datasources are not reachable.

 

The Auto Refresh and Manual Refresh is working perfectly. Why won't my Sharepoint Gateway resolve to allow me to select it from the dropdown.

 

I am having this same issue in multiple workspaces on multiple datasets that share this source.

 

burtta_1-1673991771902.png

 

1 ACCEPTED SOLUTION
burtta
Advocate I
Advocate I
5 REPLIES 5
burtta
Advocate I
Advocate I

Anonymous
Not applicable

Hi all, we raised a support ticket to Power BI support and below is the answer from them. It works for us!!  According to the PBI support, the ETA for the final solution is the last week of January. 

Below is the workaround which worked for few of the customer :

 

-> Open the below document and sign in with the power bi account.

Datasets - Bind To Gateway In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

 

->Enter the dataset id and group id

selina00_0-1674113270741.png

 

 

You will get them in the link of dataset. Click on the dataset which you are using.

 

selina00_1-1674113270743.png

 

 

->Then go to manage gateways, open the gateway which you are using , you will see I button then when you click on that you will see gateway object id.

 

->Then write that gateway object id in the space

selina00_2-1674113270744.png

 

 

->Then click on run and check if it runs successfully.

->If it runs successfully , open power bi service and check in manage gateways.

 

When you are in the "Dataset setting", you will be able to choose gateways(though for the Share Point data source, there is still an "X" in front of it) and config. the scheduled refresh. 

 

Hope it will help. 

 

Regards,

Selina

ThomasElkem
Frequent Visitor

Hello

I'm facing exactly the same issue since 2 days.

All datasets combining sharepoint online source with any other on premise source are not considered anymore by the gateway as optional.

As a consequence, it's not possible anymore to refresh them automatically.

I checked the gateway and it's allowing cloud data source update.

If someone has any idea or solution it would be higly appreciated.

TomMartens
Super User
Super User

Hey @burtta ,

 

the dialog in your screenshot only shows that it is possible to configure a gateway connection sourcing data from your Sharepoint online site. As Sharepoint online is a web data source a gateway is not required.

 

Nevertheless, after you have published your Power BI report that contains the data model to the workspace(s), you need to authenticate, this must be done as publishing (from PBI Desktop to PBI Service), does not contain any authentication information. You can enter security information for Web data sources right below the "Gateway connection" using the "Data source credentials" settings:
image.png

Of course, you can also create a gateway connection that points to the Sharepoint site. I consider this beneficial, as it's more simple to maintain. Whenever someone is "taking over" the dataset inside the workspace, it becomes necessary to re-enter the Data source credentials. This might become necessary if someone wants to change the refresh schedule.
If your organization is forcing you to change the pwd regularly, then you have to re-enter the pwd as well. Here I recommend using a Managed Service Account that does not require pwd-change. But using a managed service account almost requires using a gateway connection, if you are going down that route, you must be aware that a Managed Service Account also needs to be granted permission to the Sharepoint site and also needs a Sharepoint license.

Hopefully, this helps to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Thank you for the thoughtful response(s). It looks like it might be a 'global' issue.

 

Re: Sharepoint source suddenly un-map from gateway... - Microsoft Power BI Community

 

Ref: ICM# 360391412

 

burtta_0-1674050605451.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.