Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 17 | |
| 15 | |
| 14 |