sharepoint folder as a data source

[Malavi]

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.

[d_gosbell · Accepted solution]

---

@Malavi 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.

[FarhanAhmed]

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