topic Re: Report Server Scheduled refresh to sharepoint not working in Report Server

Report Server Scheduled refresh to sharepoint not working

Joe99 — Thu, 30 Aug 2018 00:47:46 GMT

Trying to set data source in report server data sources to sharepoint.

There are 2 options

Anonymys and windows

It works in the desktop but does not work when setting up te data source in powerbi report server.

Very frustrating when you tell the customer it can be done and there is an issue.

Re: Report Server Scheduled refresh to sharepoint not working

dustinn — Tue, 04 Sep 2018 06:30:26 GMT

Hi Joe,

I also got the same problem where I can't scheduled refresh a SharePoint source on PBI Report Server (no microsoft login) and I believe it won't be implemented sooner or later.

See v-yulgu-msft's reply.

Workaround:

1. Manually publish the pbix report to PBI Report Server.

2. Get a local database tables of your SharePoint source (This is what I did - SQL Server).

Re: Report Server Scheduled refresh to sharepoint not working

AJM — Fri, 07 Sep 2018 08:41:05 GMT

I am having the same issue, SharePoint List works in Desktop but the connection fails when configuring data source for scheduled refresh in Report Server.

The documentation suggests that on premise SharePoint list is supported for scheduled refresh.
Can anyone confirm that this is true?

Thank you

Re: Report Server Scheduled refresh to sharepoint not working

dustinn — Fri, 07 Sep 2018 09:02:01 GMT

Hi AJM,

What authentication are you using for Sharepoint List on Power BI Desktop?

Re: Report Server Scheduled refresh to sharepoint not working

AJM — Fri, 07 Sep 2018 10:39:36 GMT

I am using a Windows login.

The same account also works when used in an SSRS style data source on the report server.
One thing I do notice is that the data source under the Management section of the report is locked in as SharePoint, not SharePoint List which, along with other posts here, got me wondering whether it was using the correct connection type.

Thanks

Re: Report Server Scheduled refresh to sharepoint not working

KeithYoung — Tue, 27 Nov 2018 16:29:29 GMT

I am having same issue. Is sharepoint lists still unsupported?