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. W...
Pragati11
Super User
Super UserHi Anonymous ,
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:
Thanksm
Pragati
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.