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

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
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.

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

    Thank you very much, you are correct!
    I managed to test it on my side and it works as expected.

     

    Example:

    If my user credentials are used and this option unchecked, if any other user runs the report it will work.

    If my user credentials are used and this option is checked, if any other user without permissions to this table/view runs the report it will fail as now authentication has been done (Azure interactive) and sql database permissions checked. 

     

    Best regards,

    Nemanja Andic