Forum Discussion

nandic's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
5 years ago
Solved

Power 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 ...
  • GilbertQ's avatar
    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.