Forum Discussion
sharepoint folder as a data source
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.
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.
2 Replies
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.
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
