Forum Discussion
Power BI Report Server - Sharepoint Datasource scheduled refresh
Hi,
We have a power BI dashboard that connects to a sharepoint document. I have used the Sharepoint Folder datasource to connect to this document. It works well on the power BI report server desktop but when I publish, I am not able to set up scheduled refreshes on the data source. It shows three types of auth - Anonymous, Basic and Windows.
I have also tried connecting to the document using a web connector. It works on desktop and not on the server.
Has anyone got this to work? Any help is appreciated.
Thanks!
10 Replies
What sort of Sharepoint instance is this? Is it Sharepoint Online or an on-premise Sharepoint? If it is on-premise you can use Windows auth and enter the account details of a windows user which has access to the document. Unfortunately if it's Sharepoint Online you'll find that it's not one of the sources that currently supports scheduled refresh (see https://docs.microsoft.com/en-us/power-bi/report-server/data-sources)
What is the error you are getting? Is it just one about incorrect username/password?
Have you tried entering the username in the form of <domain>\<username> ?
