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