topic sharepoint folder as a data source in Report Server

sharepoint folder as a data source

Anonymous — Wed, 03 Nov 2021 04:05:25 GMT

Hi guys,

Is that possible to refresh the Power bi files(reports) which are getting data from a sharepoint folder?

I can connect my power bi desktop to sharepoint folder with no issue with Microsoft Authentication. However, when I upload this to report server, it does not refresh. When I try to use microsft authentication in Data source setting, it doesn't have that option.

Any help would be much appreciated.

Re: sharepoint folder as a data source

FarhanAhmed — Wed, 03 Nov 2021 07:07:00 GMT

Yes you can refresh from Sharepoint Folder

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs

Check out what authentication method that you are using

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources#list-of-supported-authentication-methods-for-model-refresh

Re: sharepoint folder as a data source

d_gosbell — Wed, 03 Nov 2021 11:19:34 GMT

Anonymous wrote:

I can connect my power bi desktop to sharepoint folder with no issue with Microsoft Authentication. However, when I upload this to report server, it does not refresh. When I try to use microsft authentication in Data source setting, it doesn't have that option.

So if you are using Microsoft Account authentication not Windows authentication then this means you are probably trying to connect to Sharepoint Online, not an on-prem instance of Sharepoint. If this is the case then the answer is - No, it's not possible to setup scheduled refresh against Sharepoint Online. Report Server only supports scheduled refresh against on-prem Sharepoint data sources.