Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |