Infero's avatar
Infero
Advocate I
10 years ago
Status:
Needs Votes

Create a report/dashboard programatically using the API

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.

7 Comments

  • basically having a kind of template dashboard and also a sql query param to select the requested data from the dataset.
  • 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
  • markt's avatar
    markt
    Regular Visitor
    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.
  • Frampers's avatar
    Frampers
    Frequent Visitor
    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
  • 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
  • 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

Recent ideas