cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Malavi
Regular Visitor

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.

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


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

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User


@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
Super User
Super User

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

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!