2783
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 DETAILS
Under Review

Hi everyone. There are some really interesting ideas in this thread, thanks for your vocal support about it! We'll consider it for the future along with other suggestions and plans. Thanks!

Comments

M

I'm begging you. Please make this happen!

M

Hi Team, We are using Tableau desktop and tableau server for one of my application. In tableau there is an option to create a workbook or reports automatically i.e. if we develop one workbook and save it in XML format , we can use the same design for multiple databases by changing the database name. That helps us to automate the designing of workbook using one template. When i gone through with Power BI , we don't see that much flexibility. Here we need to create a workbook for each database and import to server using rest APIs. If you automate the workbook creation process using one template it really helps.

M

We have a problem currently with the fact that .pbix files are very different from any other SSRS reporting artefact in terms of enterprise readiness for deployments. We have a full-featured deployment system that can deploy entire trees of reporting artefacts along with replacing datasource definitions at deploy time depending on the target environment (DEV/TRAIN/PROD) etc. This has been working nicely for years but now we are moving to PBIRS and away from SSRS native mode, users want to be able to deploy .pbix artefacts in the same way. This seems to be basically impossible because: •The file format of .pbix is not editable programatically (unlike every SSRS artefact) and so data sources cannot be changed directly which means they have to be uploaded to PBIRS and then changed with the REST API .... but ... •Datasources inside a .pbix file have no name and even the ids change every time the file is deployed to a PBIRS server. So, there is no way of matching datasources to the database of connections we use to determine datasources for a target environment during deployment. These issues make .pbix files really poor in terms of enterprise deployments. If anyone knows any way around these issues, I would be interested ... It really is a basic part of any enterprise grade managed reporting solution to be able to change reports (datasources, parameters, cacheing etc). during deployment depending on the target enviromnent.

M

I'd like to build the model programmatically, or at least from a precreated template.

M

It would be grateful if it would be possible to read and write to a .pbix file with a .NET library. So it is possible to add or modify connections, DataTables and to modify the model. I am a programmer and so it would be possible to programmaticly change and modify a pbix-File

M

Microsoft please make this happen !

M

Genuinely impressed that this has been under review for 6 years. Must be one hell of a thorough review

M

I'd like this feature too. I'd use the API to create metadata templates for the files we need to analyse in migration and data transfer projects. I currently achieve this using bespoke code that converts Excel based record layouts into machine readable templates that then need yet more code to analyse. It would also be acceptable to have PowerBI templates in a format that can be created pragmatically; such as XML, JSON format and then imported to PowerBI. I won't be able to use PowerBI efficiently until a feature such as this is provided. My organisation is getting really interested in what PowerBi can do; but this gap in the feature set is holding things back.

M

Very sad that PBI product team is completely ignoring this requirement. At least you can publish the files specs and let other smart developers to develop their own sdk libraries on top of it. This is a stop blocker for third party applications to integrate with PBI. Maybe Tableau should take all these opportunities! When you guys want to step up your game just give a buzz and maybe we'll reconsider you.

M

5 year and this post ist still under "review" ?? I'm really asking me if that ideas corner really brings anything. According to the number of views and vote, it is a core feature that a lot of us are missing, not only in powerbi service, also in powerbi for reporting services. Enough review ! please do something about it !