Skip to main content

Power BI

New

Provide a read/write API's for a) Power BI reports & elements b) Data Model

Vote (3) Share
TEEGEE's profile image

TEEGEE on 22 Feb 2018 13:40:48

it would be very useful to have API's so one could programmatically examine, build, or modify both DAX models & measures, as well as UI elements/visuals.

This would be comparable to "reflection" style coding one would do in environments like C# or MS Access, where one might write code to loop through all the properties in all your classes looking for something, or looping through all the properties in all the controls in all your forms.

These API's obviously exist, as that's what Power BI desktop UI interacts with when the user is building out a model and visuals, I would like to access those same models programmatically.

Comments (2)
TEEGEE's profile image Profile Picture

046f7463 60d0-4b47-b570-c29c3ddbb9a2 on 06 Jul 2020 00:16:04

RE: Provide a read/write API's for a) Power BI reports & elements b) Data Model

We have a very large model (350+) sources and making changes to it is very painful (slow) using PowerBI desktop. We would like to be able to programmatically add, remove, and edit queries in the data model so we can automate management and do bulk edits.

TEEGEE's profile image Profile Picture

ed6d8bda c0f6-4382-a799-b4b2d14b690b on 05 Jul 2020 23:13:18

RE: Provide a read/write API's for a) Power BI reports & elements b) Data Model

sisense lets their users do it:

https://developer.sisense.com/display/API2/REST+API+Reference+-+v1.0#RESTAPIReference-v1.0-Dashboards