SSO using OAuth for data sources in Report Server?

Question

Is SSO with OAuth for data connection available in Report Server in 2020? I found this article&nbsp;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 · Answer

Anonymous , refer if this can help
https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-oauth-ssrs

anonymous · Answer

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 · Answer

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&amp;CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&amp;tab=digestviewer

anonymous · Answer

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

d_gosbell · Answer

Unfortunately the answer is that this is not supported.
&nbsp;
If you check the list of supported data sources&nbsp;https://docs.microsoft.com/en-us/power-bi/report-server/data-sources&nbsp;
you will find that anything that uses OAuth is not supported for Direct Query or Scheduled Refresh&nbsp;

Forum Discussion

SSO using OAuth for data sources in Report Server?

5 Replies

Related content

Sharepoint online and Reporting server

Power BI Report Server migration to new servers

PBI Report Server Schedule refresh

Power BI Report Server Pricing for Sql Server 2025

Power BI Report Server licensing with SQL Server 2025 Standard when separating servers