Forum Discussion

ginoroy's avatar
ginoroy
Frequent Visitor
5 years ago
Solved

Power BI Admin API - Get Datasets

Hi,   Does anyone know how to get the datasourceUsages info when calling the Power BI Admin apis? Using either Datasets GetDatasetsAsAdmin  or Groups GetGroupsAsAdmin  expanded with datasets. The d...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi ginoroy ,

     

    How did you connect to the Rest API, PowerShell or web connector?

    Please show your M code in 'Edit Query' or the shell code.

    Please refer to the code.

    Connect-PowerBIServiceAccount

$Workspace = Get-PowerBIWorkspace -All

ForEach($Workspace in $Workspace)
{
    $Url = 'https://api.powerbi.com/v1.0/myorg/groups/'+ $Workspace.Id + '/datasets'
    Invoke-PowerBIRestMethod -Url $Url -Method Get
 }

Disconnect-PowerBIServiceAccount

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.