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 documentation refers to a DatasoureUsage array but the api does not return any

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.

4 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    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.

    • MURTAZA's avatar
      MURTAZA
      Resolver I
      4 years ago

      Hi v-lionel-msft ,

       

      I am also trying to achieve the same automation, however, this requires a user interaction to login. MFA is enabled for our tenant. and service principal with client id and client secret are unable to return Admin API. Is there a way around this? To be able to automate the process? Many Thanks 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi ginoroy ,

     

    Has your problem been solved?

     

    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.