SSO using OAuth for data sources in Report Server?

[Anonymous]

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.

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-oauth-ssrs

[Anonymous]

@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

[amitchandak]

@Anonymous , bit old one. But see if this can help

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=ee336728-b101-4313-a485-185fca5610d2&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

[Anonymous]

@amitchandak  No, that article is still about connection to Report Server, not from Report Server to an API.

[d_gosbell]

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