Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nandic
Memorable Member
Memorable Member

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 to Power BI Service
3) i typed my credentials under report -> edit credentials (there is no option for dataset as nothing is imported, it uses direct query)
4) if anyone downloads and opens the report and goes to data source settings > build connection string > their user is recognized as authentication is "Active Directory Interactive"

My questions:
1) Why do i provide credentials in 3rd step if authentication is Azure Interactive?
2) When other users run the report, will it use my (entered credentials) or it will use credentials of user who runs the report?
3) If i uncheck option: "Report viewers can only access this data source with their own Power BI identities using DirectQuery", does it mean that my credentials are sent to database even though different user is running the report?

 

nandic_0-1620903966730.png

 


Once again: report builder report based on direct query to Azure SQL database. Authentication: Azure Directory Interactive.


Thanks in advance,
Nemanja Andic

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
GilbertQ
Super User
Super User

Glad to assist!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

nandic
Memorable Member
Memorable Member

@GilbertQ , i have seen that you wrote and investigated a lot regarding Power BI Service, if you are familiar with this i would be very thankful.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors