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

[NandanHegde]

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

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

[v-shex-msft · Accepted solution]

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