cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnbasha33
Helper IV
Helper IV

Sharepoint excel refresh in Power BI Report server

HI I have an excel file is in my sharepoint site.

i can add it via web source and authentication i used is org account in Power BI desktop.

 

Schedule refresh works fine in Power BI service.

 

Where as same report schedule refresh is not working in Power BI Report server.

I have tried, anonymus, windows and basic authentication none of them are not working.

Power bi report server not supports sharepoint excel source for schedule refersh?

@mwegener @Pragati11 

9 REPLIES 9
cpapiccio
New Member

Does anyone have a solution for this? I have the same problem
Web connection to excel online-> works fine locally (can update and save)
When I try to autenticate in power bi report server, conection for automatically refresh is invalid.
Thank you!

Pragati11
Super User
Super User

HI @johnbasha33 ,

 

What kind of sharepoint connection is this? Is it sharepoint on-premises or sharepoint Online?

Sharepoint Online is not supported as a datasource in Power BI Report Server. Check the link below for supported datasources:

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11 it is a sharepoint excel and i am connecting to it as a web data source. it works fine in Power BI service. but i want that in PBIRS.

Hi @johnbasha33 ,

 

I am not sure if you went through the list of datasource that are supported by PBRS.

In your scenario you are using Sharepoint Online which is clearly not supported by PBRS, therefore your data refresh is not working.

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11  Hi Pragati,

 

though it is sharepoint source we can still get the excel file url and use it as a web connection in Power BI.

I have seen that it works fine.

 

Have you ever used such sources in PBIRS?

 

 

As per Microsoft web source is allowed for schedule refresh.

johnbasha33_0-1604394661273.png

and my source looks like below in PBIRS.

johnbasha33_1-1604394715512.png

@Pragati11 

Hi @johnbasha33 ,

 

Can you confirm if you are using sharepoint online or Web connection?

 

Based on your original question, you mentioned you are using Sharepoint online connection which is not supported in PBRS:

Pragati11_0-1604395514883.png

 

Thanksm

Pragati

 

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi Pragati, @Pragati11 
i am using a web connection as i showed above, i am pulling a excel data from sharepoint and using a web connection.

 

In power bi desktop it works with organization account authentication to fetch data,.

 

and when i publish the same report in PBIRS, we have only these 3 options, Anonymous, Basic and widnows authentication.

 

I tried all 3 but none of them are not allowing me to connect to the same web connection which i can in power bi desktop.

 

Kindly advise. 

@Pragati11 @Pragati any update on this please?

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

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

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Kudoed Authors