Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is SSO with OAuth for data connection available in Report Server in 2020? I found this article mentioning that SSO using Kerberos to data sources was available and this was in 2017. However, I haven't seen info about SSO using OAuth for data connection yet. We're able to do OAuth SSO for data connection in Power BI Desktop but not Report Server.
@Anonymous , refer if this can help
https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-oauth-ssrs
@amitchandakthanks. I saw that article but it's about connection from mobile app to Report Server. What I'm looking for is about establishing a web connection from Report Server to a web API that requires OAuth SSO, so that I can pull data from the API to the Report Server
@Anonymous , bit old one. But see if this can help
@amitchandak No, that article is still about connection to Report Server, not from Report Server to an API.
Unfortunately the answer is that this is not supported.
If you check the list of supported data sources https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
you will find that anything that uses OAuth is not supported for Direct Query or Scheduled Refresh
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |