Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 Micros...
ReportServer
SharePoint
sharepoint Folder
  • d_gosbell's avatar
    d_gosbell
    4 years ago
    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.

d_gosbell's avatar
d_gosbell
Super User
4 years ago
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.