topic Re: SSO using OAuth for data sources in Report Server? in Report Server

SSO using OAuth for data sources in Report Server?

Anonymous — Fri, 04 Sep 2020 16:07:33 GMT

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.

Re: SSO using OAuth for data sources in Report Server?

amitchandak — Fri, 04 Sep 2020 17:58:43 GMT

Anonymous , refer if this can help

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

Re: SSO using OAuth for data sources in Report Server?

Anonymous — Fri, 04 Sep 2020 21:41:38 GMT

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

Re: SSO using OAuth for data sources in Report Server?

amitchandak — Sat, 05 Sep 2020 07:05:13 GMT

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

Re: SSO using OAuth for data sources in Report Server?

Anonymous — Mon, 14 Sep 2020 16:11:19 GMT

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

Re: SSO using OAuth for data sources in Report Server?

d_gosbell — Thu, 17 Sep 2020 23:20:15 GMT

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