Forum Discussion

lapora1976's avatar
lapora1976
Regular Visitor
8 years ago

Power BI API - Patch Import Azure SQL DB Datasource with Windows credentials

We are integrating Power BI Embedded within our SAAS application with the need to deploy reports through different environments (Development, System Test, Production) without user intervention. I hav...
v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
8 years ago

 

I think the issue here should be related to Permissions (credential type) under the Azure SQL Database.

Azure SQL Database only supports two types of authentication:

1. SQL Authentication

2. Azure Active Directory Authentication,

and AAD authentication supports the following methods of connecting to a database using Azure AD identities:

  • Using integrated Windows authentication
  • Using an Azure AD principal name and a password
  • Using Application token authentication

For more details about how to configure the AAD Authentication, please check:

Azure SQL Database access control

Use Azure Activa Directory Authentication for authentication with SQL Database, Managed instance, or SQL Data Warehouse

How to configure 

 

And the supported credential type for the Power BI API patch is:

"Basic|Windows|Anonymous|OAuth|Key"

There is no Azure Active Directory Authentication listed.

 

Regards,

Michael