Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Source Connection Properties, Azure SQL question

I have a paginated report that gets data from an Azure SQL Server. In the SQL code in the Dataset, one column is CURRENT_USER that gets me the AD user email address when running the SQL code outside...
Azure SQL
Data Source Report Server
Power BI report builder
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ，

 

Your issue is more related to azure sql db. I would also suggest you open a thread in azure sql db forum. 

 

As far as I know, you can use ActiveDirectoryIntegrated in connection string :

 

Use connection string like below:

string ConnectionString = @"Data Source=n9lxnyuzhv.database.windows.net; Authentication=Active Directory Integrated; Initial Catalog=testdb;";
SqlConnection conn = new SqlConnection(ConnectionString);
conn.Open();

 

For more details, please refer to https://stackoverflow.com/questions/49771761/azure-sql-database-active-directory-integrated-authentication

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai