topic Re: Not able to schedule Power BI dashboard refresh in Power BI workspace when source is Sharepoint List in Developer

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

ShivPB — Mon, 11 Apr 2022 06:58:46 GMT

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!

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

V-lianl-msft — Thu, 14 Apr 2022 02:46:19 GMT

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.

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

Anonymous — Mon, 09 May 2022 10:28:57 GMT

Same problem I am facing.

Kindly guide