Report Server Scheduled refresh to sharepoint not working

[Joe99]

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.

[KeithYoung]

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

[AJM]

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

[dustinn]

Hi @AJM,

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

[AJM]

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

[dustinn]

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).