Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Power BI Designer API
Submitted by
marco4
on
03-27-2015
09:20 AM
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
See more ideas labeled with:
Comments
- « Previous
-
- 1
- 2
- 3
- …
- 10
- Next »
- « Previous
-
- 1
- 2
- 3
- …
- 10
- Next »
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Latest Comments
- Tochukwu on: Take over Rest API should takeover the artifact al...
-
kleigh
on: List Slicer Bug
-
YSD on: Embed RTI Dashboard In PowerBI Report
- AlijH on: Enable notebookutils (and other) methods to work w...
-
kleigh
on: Replace Pie with Sunburst chart- Enhanced capabili...
- Imjkrao on: Domain specific Tags
- ThornKevin on: Identifying which specific user or report is causi...
-
NaamaTsafrir on: Detect and control unused Fabric/Power items in th...
- ThornKevin on: OAuth 2.0 Rest API Support
- joannaAffirmed on: Support workspace scope for job events
Idea Statuses
- New 15,347
- Need Clarification 14
- Needs Votes 22,642
- Under Review 645
- Planned 274
- Completed 1,657
- Declined 228
-
Power BI
38,996 -
Fabric platform
559 -
Data Factory
458 -
Data Factory | Data Pipeline
331 -
Data Engineering
275 -
Data Warehouse
198 -
Data Factory | Dataflow
177 -
Fabric platform | Workspaces
158 -
Fabric platform | OneLake
135 -
Real-Time Intelligence
125 -
Fabric platform | CICD
99 -
Fabric platform | Capacities
83 -
Fabric platform | Admin
74 -
Real-Time Intelligence | Eventhouse and KQL
63 -
Fabric platform | Governance
57 -
Fabric platform | Security
57 -
Data Science
53 -
Real-Time Intelligence | Activator
52 -
Data Factory | Mirroring
40 -
Fabric platform | Support
36 -
Databases | SQL Database
33 -
Real-Time Intelligence | Eventstream
30 -
Databases
27 -
Fabric platform | Data hub
23 -
Fabric platform | Real-Time hub
4 -
Data Factory | Apache Airflow Job
4 -
Product
2