Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Team,
Is there a way to extract dataset owners using Power Shell script. If it is possible please send me the Powershell script.
Thanks in advance!
Solved! Go to Solution.
Hey @Anonymous ,
here you will find a Powershell script:
Import-Module -Name MicrosoftPowerBIMgmt
# Connect as Serviceadministrator
Connect-PowerBIServiceAccount
$datasetID = " ... your datasetid goes here ..."
$uriAPICall = "https://api.powerbi.com/v1.0/myorg/datasets/$datasetID/users"
$uriAPICall_Obj = Invoke-PowerBIRestMethod -Url $uriAPICall -Method GET
$uriAPICall_Obj
Disconnect-PowerBIServiceAccount
Read here about the API function endpoint:
Datasets - Get Dataset Users - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Hopefully, this will help to tackle your challenge.
Regards,
Tom
Hey @Anonymous ,
here you will find a Powershell script:
Import-Module -Name MicrosoftPowerBIMgmt
# Connect as Serviceadministrator
Connect-PowerBIServiceAccount
$datasetID = " ... your datasetid goes here ..."
$uriAPICall = "https://api.powerbi.com/v1.0/myorg/datasets/$datasetID/users"
$uriAPICall_Obj = Invoke-PowerBIRestMethod -Url $uriAPICall -Method GET
$uriAPICall_Obj
Disconnect-PowerBIServiceAccount
Read here about the API function endpoint:
Datasets - Get Dataset Users - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Hopefully, this will help to tackle your challenge.
Regards,
Tom
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
24 | |
20 | |
19 | |
15 | |
14 |
User | Count |
---|---|
34 | |
27 | |
27 | |
23 | |
21 |