How to setup Sharepoint list datasource auto refresh on Power bi report server

[sanjay009]

i have couple of reports that pulling data from sharepoint list. how do i setup autorefresh on power bi report server. i have only two options in dropdown windows authentication and Anonmyous Itried windows authentication with office 365 user/pwd and also anonymaous both does not work. Do we have solution or work around (not using gateway my company don't support) to auto refresh sharepoint list on power bi report server.

i am getting error:  SharePoint: Request failed: Unable to connect to the remote server

[d_gosbell]

Unfortunately there is no easy solution for this. Sharepoint lists on Office 365 are explicitly listed as not supported for scheduled refresh https://docs.microsoft.com/en-us/power-bi/report-server/data-sources you either need to refresh in desktop and upload periodically or look at pulling the data to some other source that is supported for scheduled refresh.