Forum Discussion

hale's avatar
hale
Icon for Helper II rankHelper II
3 years ago
Solved

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.   Ther...
Need Help
  • BenElliott's avatar
    BenElliott
    3 years ago

    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")

     

     

     

hale's avatar
hale
Icon for Helper II rankHelper II
3 years ago

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.

 

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

 

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 out