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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
NandanHegde
Super User
Super User

Get the Authentication type details of datasource creds and report type(Import/ Live)

Hello Team,

I have a requirement wherein the dataset is configured by a different user within the same workspace .

I need to get the below details for that dataset/Report :

 

1) Whether the report is Import mode or Direct query/ConnectLive without downloading the Report as PBBIX file

2) I need to get the authentication type used by that user in the credentials for the dataset

Powerbi.PNG

 

I cannot take over the dataset as it might reset the credentials.
So is there any way in PowerBi service / via REST APIs that I might get the above 2 required details.

 

Thanks




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @NandanHegde,

#1, You can use dataset related REST API to check the detailed settings of your dataset data sources information. (you need to get the group id and correspond dataset id to find out the specific data source)

Datasets - Get Datasources In Group 

#2, Please check the following link about 'get gateway Datasource in group' API to extract the specific gateway Datasource configuration:

Datasets - Get Gateway Datasources In Group 

Reference links:

Register an Azure AD application to use with Power BI 

Docs Power BI REST APIs Datasets Overview 

BTW, if you do not have enough permission to execute these rest API, you can also check on power bi audit logs. It also logged a lot of operations of power bi service that you can find out specific information from its logs.

Track user activities in Power BI 

Regards,
Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @NandanHegde,

#1, You can use dataset related REST API to check the detailed settings of your dataset data sources information. (you need to get the group id and correspond dataset id to find out the specific data source)

Datasets - Get Datasources In Group 

#2, Please check the following link about 'get gateway Datasource in group' API to extract the specific gateway Datasource configuration:

Datasets - Get Gateway Datasources In Group 

Reference links:

Register an Azure AD application to use with Power BI 

Docs Power BI REST APIs Datasets Overview 

BTW, if you do not have enough permission to execute these rest API, you can also check on power bi audit logs. It also logged a lot of operations of power bi service that you can find out specific information from its logs.

Track user activities in Power BI 

Regards,
Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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