Trying to determine the account behind the data model

[U156531]

I need to to know what account id is retreiving the data into my PBI desktop report. Does anyone know how I determine this?

Thanks

[girishthimmaiah · Accepted solution]

The retrieval of the account in a Power BI Desktop report can be seen by the methods:

1. Power BI Desktop (Current User)
From the menu, click on File > Options and settings > Data source settings from the Path Editor.
Find the data source from the list and click Edit Permissions to see which account is being used.
2. Using DAX To Get For Logged-In User (For User Restricted Data)
If your report design uses Row-Level Security (RLS) or AAD authentication, you may create a measure to check for the logged-in user:

DAX
UserEmail = USERPRINCIPALNAME()
Add this measure to a table or card visual to see which account is running the report.
3. Power Query (If API or Cloud Data Is Used)
Open Power Query Editor (Transform Data).
On the menu, check View > Query Dependencies to determine the data source.
4. SQL Server (If Using SQL As A Data Source)
Let's say you are querying a database:

SQL
SELECT SYSTEM_USER;
This returns the SQL login used for the connection.

[girishthimmaiah · Accepted solution]

The retrieval of the account in a Power BI Desktop report can be seen by the methods:

1. Power BI Desktop (Current User)
From the menu, click on File > Options and settings > Data source settings from the Path Editor.
Find the data source from the list and click Edit Permissions to see which account is being used.
2. Using DAX To Get For Logged-In User (For User Restricted Data)
If your report design uses Row-Level Security (RLS) or AAD authentication, you may create a measure to check for the logged-in user:

DAX
UserEmail = USERPRINCIPALNAME()
Add this measure to a table or card visual to see which account is running the report.
3. Power Query (If API or Cloud Data Is Used)
Open Power Query Editor (Transform Data).
On the menu, check View > Query Dependencies to determine the data source.
4. SQL Server (If Using SQL As A Data Source)
Let's say you are querying a database:

SQL
SELECT SYSTEM_USER;
This returns the SQL login used for the connection.

[U156531]

This great information! Is there a method to force the desktop pbi to use a different account other than the one I'm logged in with? 

[Anonymous · Accepted solution]

Hi, @U156531 

Thanks for the reply from girishthimmaiah. When you log in to your account in Power BI Desktop and set the sensitivity tab, only accounts in your organization can log in to your personal account and open the pbix files you share. You can read the following document in the links.

Sensitivity labels from Microsoft Purview Information Protection in Power BI - Power BI | Microsoft ...
Apply encryption using sensitivity labels | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum