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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
hale
Helper II
Helper II

Sharepoint source suddenly un-map from gateway and cannot be added again

Hi guys,

My dataset has been configured to scheduled refresh and been working fine.

Only just then the refresh failed and upon checking, I see one of my data source become un-mapped.
17.01.2023_01.29.35_REC.png

 

There is a link as the screenshot above to add to gateway but no dropdown to choose. After trying adding another SharePoint source again, the dropdown box is still not appearing.

Anyone having the same issue since today?

1 ACCEPTED SOLUTION

Easy fix here:  Create a new SharePoint DataSource, and where you enter the site URL just add a forward slash on the end.  This testing datasource shows in the dropdown, but all of my other SharePoint sources are not in the list (they dont have forward slash by default when you click "create datasource")

 

BenElliott_1-1674057357477.png

 

 

View solution in original post

18 REPLIES 18
Gasvila
New Member

We' re suffering the same issue since the start of the week. Published apps reload just fine as long as nobody "takes control" of the dataset. When you take control, then the "Apply" button remains grey and is not possible to reconfigure the gateaway or the schedule parameters.

As mentioned in this post, it only happens in datasets with sharepoint and another on-premise datasource. Sharepoint by itself works just fine. I'm interested in any method to receive news from ICM#: 360391412 as burtta asked.

 

Kind regards,

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

BenElliott
Frequent Visitor

Same exact issue here.  Started a couple days ago and all of our datasets failed refresh.  After reautheticating the sharepoint credentials it was completing refresh however the Sharepoint is unmapped.   Then I updated our gateway to the latest version but still did not resolve.

 

We cant create any new schedules until it gets resolved.

Easy fix here:  Create a new SharePoint DataSource, and where you enter the site URL just add a forward slash on the end.  This testing datasource shows in the dropdown, but all of my other SharePoint sources are not in the list (they dont have forward slash by default when you click "create datasource")

 

BenElliott_1-1674057357477.png

 

 

My URL does have a forward slash at the end but still not being able to map 😞

19.01.2023_09.41.50_REC.png

 

I guess the only other thing I did differently was to manually create my datasource, not sure where the magic came from that worked for me!

BenElliott_0-1674082486798.png

 

This worked for me as well!! Thanks.

OMG, it works. Thanks so much, you're legend 😍!!!

hale
Helper II
Helper II

Another update: my PRD dataset is still refreshing fine even though the mapping to SharePoint is still not mapped. I did some experiments with my QAS dataset and now Power BI Service is saying my one of my datasource is deleted. When I tried recreating it, the dataset cannot be configured to schedule refresh anymore due to the fact that gateway settings require all data sources to be mapped. Due to the amount of data that I am working with, I need the scheduled refresh via gateway to work. Now I am too scared to touch the PRD dataset 🙂

 

 This message appears after I tried a few things with this dataset. I am pretty that happens when 1 of the parameter changes value.

574f91ce-44b4-424e-b971-2fda3e2f649d.png

 

Click on recreate cloud data sources, the message is still apearing 😞

52f5bd46-3dce-47d1-b390-41fc467b6b49.png

 

The schedule refresh option is now completely greyed out. The gateway mapping can not be saved anymore so I cannot rebuild my dataset. This is BAD. Please fix it 

Schedule refresh option is now completely greyed outSchedule refresh option is now completely greyed out

 

Nyakumbo
Regular Visitor

I have reverted back to a personal gateway and it has worked! We can use this as a temporary solution as we wait for the team to fix the issue with the standard gateway

Anonymous
Not applicable

Not a permanent solution for enterprise solutions but I can confirm it works!

burtta
Advocate I
Advocate I

I am having this same issue and have also posted a plea for help.

 

Sharepoint Gateway - Microsoft Power BI Community

hale
Helper II
Helper II

Quick update: the gateway is still not mapping properly with SharePoint for me, however, the last 2 scheduled refreshes were "unexpectedly" successful. I even try manually import the data via XLMA endpoint and it still works. That's strange.
Hopefully this will be resolved soon. 

Anonymous
Not applicable

We are experiencing the same issue. Had to update the report and by publishing again, the gateway couldn't be properly set.

I'm currently refreshing the report in Power BI Desktop and publishing everyday.

v-yangliu-msft
Community Support
Community Support

Hi  @hale ,

 

According to research, a similar issue has been reported internally,(ICM#: 360391412).

I will update here once I get any information.

 

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.

Is there a way for the community to follow the development of the ICM#: 360391412?

encounter same issue for me start from tonight

Nyakumbo
Regular Visitor

I have the same issue

Helpful resources

Announcements
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!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.