Feature Request: Add Update Tiles in Group to Power BI API

[conorh-dev]

Hi,

Based on some recent posts it appears there is no solution to an issue we are having when trying to implement CICD principles into our custom Power BI DevOps pipeline around deploying a Dashboard.

If the PowerBI API could be extended so that we can make the changes as outlined below then it would allow us to fully automate our solution as the enterprise requires. It is currently not a feasible solution considering the amount that is being spent on PowerBI resources.

Power BI API - Dashboards
https://learn.microsoft.com/en-us/rest/api/power-bi/dashboards

The new API method would need to allow us to update the following tile details to allow us to set a custom link from a tile to a report.

Before:

{
  "@odata.context": "http://wabi-north-europe-k-primary-redirect.analysis.windows.net/v1.0/myorg/groups/394g234vg-e5a6-4d39-ab69-fb6b988c0986/$metadata#tiles",
  "value": [
    {
      "id": "dc0eab70-fc8a-4da4-b022-3ae593f7a595",
      "title": "Sales by Store Analysis",
      "embedUrl": "https://app.powerbi.com/embed?dashboardId=7a5224de-52e3-47a8-bd2e-6581",
      "rowSpan": 0,
      "colSpan": 0,
      "datasetId": "8s978ds9-8c22-402e-acb1-884fdadc04ce"
    },
    {
      "id": "50438ca9-10ae-4775-8092-a48a9ef07f3e",
      "title": "Wastage by day",
      "embedUrl": "https://app.powerbi.com/embed?dashboardId=7a5224de-52e3-47a8-bd2e-6581",
      "rowSpan": 0,
      "colSpan": 0,
      "datasetId": "8s978ds9-8c22-402e-acb1-884fdadc04ce"
    }
  ]
}

After:

{
  "@odata.context": "http://wabi-north-europe-k-primary-redirect.analysis.windows.net/v1.0/myorg/groups/394g234vg-e5a6-4d39-ab69-fb6b988c0986/$metadata#tiles",
  "value": [
    {
      "id": "dc0eab70-fc8a-4da4-b022-3ae593f7a595",
      "title": "Sales by Store Analysis",
      "action": {
        "openUrl": {
          "targetUrl": "/reports/b431e75c-65fc-4651-bbbd-ad0e7f26e8e3"
        }
      },
      "embedUrl": "https://app.powerbi.com/embed?dashboardId=7a5224de-52e3-47a8-bd2e-6581",
      "rowSpan": 0,
      "colSpan": 0,
      "datasetId": "8s978ds9-8c22-402e-acb1-884fdadc04ce"
    },
    {
      "id": "50438ca9-10ae-4775-8092-a48a9ef07f3e",
      "title": "Wastage by day",
      "action": {
        "openUrl": {
          "targetUrl": "/reports/e08db818-16df-4d7a-9229-bb7d42d21fde"
        }
      },
      "embedUrl": "https://app.powerbi.com/embed?dashboardId=7a5224de-52e3-47a8-bd2e-6581",
      "rowSpan": 0,
      "colSpan": 0,
      "datasetId": "8s978ds9-8c22-402e-acb1-884fdadc04ce"
    }
  ]
}

The ideal solution for us would be that we can map the Dashboard tile in the workspace to a specific report name in the same workspace as this would remove the need for us to have to query the report ids in a specific workspace and update the tiles like the above.

It is one of the last issues we are having after spending an entire year trying to work with PowerBI and implement an enterprise grade CICD solution.

Or solution has a Development workspace, Testing workspace, UAT workspace and over 25+ Production workspaces that all need to be updated by the pipeline. It is not feasible for any of these tasks to have to be handled by the developer through the PowerBI Service UI, or by any other manual mechanism.

It is holding us back from delivering a satisfactory solution to customers so if there is something I can do or provide to push this further then please let me know.

Thanks,
Conor

[lbendlin · Accepted solution]

not quite the right place. 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[conorh-dev]

Hi,

Thanks for the reply.

I've already raised it as an idea but it appears that on that platform you can't add code snippets, or possibly only mine was flagged, because there is a malicious input filter blocking the json.

I also struggled to put in the links, so in the end I had to comment a link back to this post as an idea suggestion.

Also, when it was suggested on my other post here last week, the Fabric Ideas site was not accessible.

Here is the link to the idea for anyone interested, and please vote 🙏 https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=9606acba-d9db-ee11-a73d-000d3add4436

Thanks again for your help.