Forum Discussion
nandic
Resident Rockstar
5 years agoPower BI - data source credentials - Azure Directory Interactive
Hi, I am in doubt which authentication goes behind the scene when running the report. 1) report created via Report Builder (direct query connection to Azure SQL database) 2) report is published ...
- 5 years ago
Hi nandic
My understanding is the following:
1. If you have the tick enabled it will then automatically use the users logged in details to access the Azure SQL Database. So you will need to ensure that those user accounts have got the right access to the Azure SQL Database.
2. If you remove the ticket (Disabled) and you put in your credentials, your credentials will then be used to run queries against the Azure SQL database.