Skip to main content

Power BI

Under Review

Data Source API

Vote (39) Share
Kirk Munro's profile image

Kirk Munro on 08 Jan 2016 04:58:09

Provide an API for Power BI Desktop that allows developers to create their own data sources. It's literally the very first feature I went looking for in Power BI. If you had such a feature, you wouldn't have to do all of the work yourselves for individual data source requests (of which there are quite a few already under review). My personal interest is to create a PowerShell data source , so that PowerShell can be used as glue to open Power BI up to many other data sources (including REST, which was one of the requests). Being able to push data into Power BI via PowerShell is one need (already satisfied with the PowerBIPS module), but there is also a need to be able to pull and refresh PowerShell data using a gateway without having to deal with intermediate csv files on disk.

Comments (3)
Kirk Munro's profile image Profile Picture

fdf1d6d5 36da-47bc-8edb-52b4b3bf105a on 05 Jul 2020 22:52:30

RE: Data Source API

The feature will indeed be very help. I am currently developing a Drupal module that gets data out one of our HMIS and converts it into a csv file to be uploaded into Power BI. If only Power BI had an api I could consume and thus be able to upload the data.

Kirk Munro's profile image Profile Picture

4969b57a 2cf2-480d-8521-99843675d3ad on 05 Jul 2020 22:44:39

RE: Data Source API

This will be a great addition to the product. I consider PBI Desktop to be a great analytics tool, not just a development tool, and allowing the community to create data source connectors will explode the oppertunities. Even if it is only for the dektop app

Kirk Munro's profile image Profile Picture

8e719df0 4260-4d32-82fb-8e73ea224705 on 05 Jul 2020 22:20:43

RE: Data Source API

This would be a great feature. Note that there is already API functionality to SEND data FROM PBI but no way to Restfully get data INTO PBI.