cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 10
Highlighted
Super User III
Super User III

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

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)

Highlighted
Frequent Visitor

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

Hi - Thanks for your reply. This is an on-premise Sharepoint and we tried Windows Auth and that did not seem to work.

 

 

Highlighted
Super User III
Super User III

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

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> ?

Highlighted
Frequent Visitor

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

Sorry for the delay. It is showing up as incorrect username/password

Highlighted
Helper II
Helper II

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

I have the same issue when trying to scheadule updates to a report. Did you find a solution to this @jincysarah ?

 

I have tried specifing domain and leaving it out and always getting the message: Log on failed. Ensure the user name and password are correct.

 

I can, with success, open a browser as this user and read the list that is the data source used in my report.

Highlighted
Frequent Visitor

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

@martinlarsson - We tried Power BI service and that seemed to work using a web connector. So we just moved our report to the cloud and I did not  try to make it work on Power BI report server. Hope that helps.

Thanks!

Highlighted
Helper II
Helper II

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

Thanks @jincysarah. I assume you are using SharePoin Online as datasource? We are using an on-prem SharePoint so your solution will probably not work for us. 😞

Highlighted
Helper I
Helper I

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

Hello, @d_gosbell 

 

I face with the same issue that authentication is failed for connecting power bi report server to sharepoint on-premise.

Though I put correct account and password, it shows always it is failed.

Thing wierd is when I put the path to url in a web browser or windows explorer? it works but not in the data source of the power bi report server.

 

If you have any experience with this, please help me. 😉 thanx

Highlighted
Regular Visitor

Re: Power BI Report Server - Sharepoint Datasource scheduled refresh

Have anyone had any advance on this? I'm having the same problem

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors