Forum Discussion
Model Refresh with Azure SQL and Report Server
chris2 wrote:
... for security reasons I would like to use the Azure AD - Username and Password option
Sorry, but you cannot do this. AzureAD is based on OAuth authentication and this is not supported with Report Server (see the first sentence in this section Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn)
You can only use Azure AD authentication with the cloud service.
Hi d_gosbell.
thank you for your reply. Using a SQL Login is working. I tried this already. But for security reasons I would like to use the Azure AD - Username and Password option as shown here (screenshot is from the SQL Management Studio):
chris2 wrote:
... for security reasons I would like to use the Azure AD - Username and Password option
Sorry, but you cannot do this. AzureAD is based on OAuth authentication and this is not supported with Report Server (see the first sentence in this section Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn)
You can only use Azure AD authentication with the cloud service.