Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Power BI Designer API

Power BI Designer saves a local PBIX file, which can be a file to export data and data model – in other words, it’s a format that contains a complete semantic model. All the applications that today export data in several formats (CSV, Excel, XML), might provide a richer semantic model exporting a PBIX file. Many ISV/SI that have OLTP and other applications that stores data in some database, usually struggle to offer a compelling BI story to their customers. The smaller they are, the more they feel this pressure because probably the effort they can put in their custom software is minimal. Today these ISV/SI integrate their solution with external vendor technologies (QlikView is a common choice here). However, the cost of such a solution for the end user is not always appealing, and for this reason the MS partner ecosystem always look for components (charts and pivot tables) to integrate in their solutions. Providing them an easy and inexpensive way to produce PBIX files “ready to use” straight from their product/solution would provide several benefits: - Customers would have something ready to be uploaded to Power BI service - ISV/SI would be able to provide a BI solution integrated with MS ecosystem - ISV/SI can implement solutions like “send a PBIX file via mail every week to all the agents including only the data of their prospects/customers” - Today they already do that using the .CUB format, which can be consumed by both Excel and custom applications - Microsoft would increase the number of Power BI users very quickly - Small ISV/SI would be able to implement such integration very fast What I propose to do is, in descending order of importance: 1) Support Power BI Designer as a local engine with an API that can be used by anyone and officially support local connections by other programs (starting from Excel) - The API should provide the ability to create a data model and to populate it with data by just using API, without any manual interaction - Providing the ability to connect from other clients (today it is possible but not officially supported) would increase the adoption. 2) Document and “open” the PBIX file, so that it can be generated by anyone - I think that this is easy for the data model, but not for the data. - But without the data, this model would be not so useful, requiring a manual refresh to be populated. 3) Open source the Power BI Designer - Not really a priority in my opinion, but if the first two wouldn’t be possible, this one could be ok
Status: Planned
Comments
chad_lorenz
New Member
Under review for 4 years, nice PBI. This would save so much time. Or, at least, be able to toggle whether the measure gets calculated instantly or later (similar to Excel), so it's just a copy paste exercise in the interim
admin200
New Member
The development experience with Power BI data models must be improved, especially in terms of UI speed/responsiveness. Even simple changes on a relatively small and simple model take too long to apply... At the very least it's necessary to "be able to toggle whether the measure gets calculated instantly or later (similar to Excel)".
esey_misginna
New Member
Under review for four years?
Billy_Marsh
New Member
Creating multiple measures has become a very time consuming exercise as my model has grown; some way of adding multiple at once would be an absolute lifesaver and be a real silver-bullet for productivity!
swatts1
New Member
Need to add tons of template measures. Please add this feature!
jesus2
New Member
Please we need it !
pbiideas1
New Member
We are strugeling with this for all our technical teams in our company. It looks like this will be a reason for us to move to another bi product, like looker because it does it much simpler for them
mycwid
New Member
Hello, this is a final missing step for automating Power BI Reports deployment and this feature is highly desirable. Please add as soon as possible. Thank you
schmitt
New Member
Any progress here ?
rich_brooks
New Member
This is critical for an upcoming project. We need an API to create something like Set oApp = New PBIApp () Set oReport = PBIApp.Reorts.Add () Set oMatrix = oReport.Visualization.Add("MS.Matrix") oMatrix.X = 0 oMatrix.Y = 0 oMatrix.Width = 200 oMatrix.Height = 200 oMatrix.Columns.Add(DataModel.Table.FieldName) etc... etc.. Please make it happen.