Sharepoint Gateway

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