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

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

 

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

 

 

 

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

 

 

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