Forum Discussion

zhhorton's avatar
zhhorton
New Member
11 months ago
Solved

[ISSUE] Power BI REST API - GetDashboardsAsAdmin

Hello,   In an attempt to retrieve some information from the Power BI REST API (specifically, the GetDashboardsAsAdmin), we have run into an issue where the expand parameter is not accepted and wil...
data engineering
  • tayloramy's avatar
    tayloramy
    11 months ago

    Hi zhhorton, 

    WHen using $expand, a $top also needs to be specified. 

     

    In my enviornment: 

    GET https://api.powerbi.com/v1.0/myorg/admin/dashboards?%24expand=tiles

    returns a 400 response with this body: 

    {
  "error": {
    "code": "InvalidRequest",
    "message": "This API expects $top query option to be provided."
  }
}

     

    Where as this:

    GET https://api.powerbi.com/v1.0/myorg/admin/dashboards?%24expand=tiles&%24top=10

    returns a 200 code with data

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.

     

tayloramy's avatar
tayloramy
Super User
11 months ago

Hi zhhorton, 

WHen using $expand, a $top also needs to be specified. 

 

In my enviornment: 

GET https://api.powerbi.com/v1.0/myorg/admin/dashboards?%24expand=tiles

returns a 400 response with this body: 

{
  "error": {
    "code": "InvalidRequest",
    "message": "This API expects $top query option to be provided."
  }
}

 

Where as this:

GET https://api.powerbi.com/v1.0/myorg/admin/dashboards?%24expand=tiles&%24top=10

returns a 200 code with data

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.

 

zhhorton's avatar
zhhorton
New Member
11 months ago

Thank you tayloramy, that is very helpful.

 

I have found the $top parameter is necessary much more than the documentation mentions which causes some confusion. I appreciate your help!