Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Eric Holtz 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

TEEGEE 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