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 (6)
RE: Create a report/dashboard programatically using the API
Moste of my Dataset are built from SQL View, The SQL views are well structured and so the creation of the DataSet it's just "Not inteligent Work" just adding the view, put the link and put the right Types, decimales, etc... on the fields.So il would like to be habe to create and generate my PBIX file programayicaly and automaticaly Publish the same DataSet to my customers (they use the same Kind of software (and database infrastructure) but with there one Tenant more that 100 hundred customers) It would be a killer feature for company like mine
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
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
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.
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
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.