Forum Discussion
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?
9 Replies
HI Anonymous ,
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
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 Anonymous ,
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
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!
