[ISSUE] Power BI REST API - GetDashboardsAsAdmin

[zhhorton]

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 will return a 400 Client Error: Bad request for url. Removal of the ?$expand=tiles returns the expected result, so it is not any other issue aside from the format of the GET request URL.

Link to referenced documentation (here)

Has anyone else run into this issue and found a way around it? The documentation provided may no longer be up to date. Thanks.

[tayloramy · Accepted solution]

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]

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!