Indeed a critical feature!
For a start it would be great with just a description of files (and formats) of the PBIX content. I.E. which compression techniques are used etc.
It would be great to programmatically create and modify pbix files!
Please foresee such an API / Object model to edit PBIX. We really need to be able to provision reports and dashboard and just change the connection string in them.
Karish: Metadata (data model, queries, and reports ) are already text files (PBIX is an Open XML file - it's just a ZIP). However, the data in the model are compressed and require an API to access that feature.
Another option would be to make pbix a text format. With Tableau we can edit TDS files (simple XML), so we don't actually need an SDK.
Yes it would be great if there is Power BI SDK that can be use by .Net framework to create/update PBIX files via program.
This is a critical feature for ISV adoption of PowerBI Embedded! The ability to programmatically create the PBIX, then publish and embed, is a key enabler.
This would allow the ability to programatically add measures to multiple tables. And to reduce human error when doing repetitive tasks. Please add feature/specifications to allow the model to be updated outside of PowerBi. What XML files to edit? etc...
It would save a lot of time for us, since we have to create lots of custom reports from many data files and setting up all these data sources are time consuming. Thank you very much in advance for considering this. Any plans to implement it?
Administrator on 12/18/2014 7:56:59 AM
Great idea, Marco. Our Developer APIs are still evolving and this is great feedback. Anyone else think this is an area in which we should invest? Please vote!