Skip to main content

Power BI

New

Create a report/dashboard programatically using the API

Vote (86) Share
Gunther's profile image

Gunther on 22 Apr 2016 16:09:12

As a developer I want to be able to create individual dynamic reports so that I can create personalized dashboards/reports for my users.

e.g. User A can only see the data in a chart that is he is allowed to see, and this can be generated automatically using the API.

Comments (5)
Gunther's profile image Profile Picture

0a471a63 de64-4d08-a366-342dd0521e2e on 05 Jul 2020 23:24:27

RE: Create a report/dashboard programatically using the API

We can already provision dashboards, and clone tiles to dashboards via API. We need API endpoints for pin visual to a dashboard and remove tile from a dashboard. If we had that functionality we can largely make dashboards via the API. Be nice to be able to change tile order etc. via API. I just don't understand the complete lack of parity between the portal and the public API. As an ISV Power BI Embedded is showing itself to be quite weak

Gunther's profile image Profile Picture

eb1d9462 6f16-4d7b-9be3-b68b9a7cc602 on 05 Jul 2020 23:19:34

RE: Create a report/dashboard programatically using the API

Or at least being able to create a .pbix from a .pbit via powershell, then publish to web so you can release updates to reports automatically

Gunther's profile image Profile Picture

1e506787 c689-46c4-ac54-cf1328fc44cb on 05 Jul 2020 22:32:18

RE: Create a report/dashboard programatically using the API

We have the ability to create datasets and add data with the APIs, now if we could create basic dashboards programmatically that would be great.

Gunther's profile image Profile Picture

c39caa1e 20c4-4f7c-a914-da85ccb2e141 on 05 Jul 2020 22:28:07

RE: Create a report/dashboard programatically using the API

Hello,

There is a Azure Authentication library available for play with Power BI REST API. The Azure will provide you JWT access token and you can embed this token in header of your every call to Power BI.

Link:

https://github.com/AzureAD/azure-activedirectory-library-for-java/

For more details of Authentication please refer follow question:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15743572-power-bi-authentication-using-rest-api-without-gui

Gunther's profile image Profile Picture

470bc8da 7d7d-4ae4-9429-7aa918f6eeb5 on 05 Jul 2020 22:20:06

RE: Create a report/dashboard programatically using the API

basically having a kind of template dashboard and also a sql query param to select the requested data from the dataset.