Not able to schedule Power BI dashboard refresh in Power BI workspace when source is Sharepoint List

[ShivPB]

I have connected onpremise sharepoint list in Power BI dashboard. I am able to refresh the list on Power BI desktop but when I publish the same copy in Power BI workspace , not able to schedule auto refresh. To enable auto refresh, first we need to make the data source connection . While doing the data source connection, I can see only these two authentication options in the list. Oauth menthod is not coming under it. Thats why not able to enter username and password for sharepoint site connection as like I have done on desktop.

Note :

While making connection on Power BI desktop :

I have selected data connection option as a sharepoint list and connected to list by using username and password .

Please find below screenshots for the reference:

Looking forward for your help on this please.

Thank you!

[V-lianl-msft · Accepted solution]

Hi @ShivPB ,

According to your description, you are using on premise sharepoint, so you need to configure the gateway for this and configure the scheduled refresh.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-local-drive 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Same problem I am facing.

Kindly guide