Forum Discussion

Microsoft Employee

11 years ago

Solved

SSIS output to PowerBI.com data source

Integrating SSIS with PowerBI.com so that an output Task can be a DataSet in Power BI would be very helpful.

jbocachica
11 years ago
That's already possible, just remember that you can wrote your own sources and destinations in SSIS and using the REST API you can send data to a Dataset and even create that Dataset in the flight http://docs.powerbi.apiary.io/#

Regards

jbocachica
Resolver II
11 years ago
That's already possible, just remember that you can wrote your own sources and destinations in SSIS and using the REST API you can send data to a Dataset and even create that Dataset in the flight http://docs.powerbi.apiary.io/#

Regards
nancy1989
Regular Visitor
8 years ago
REST API is becoming the most popular way to communicate between multiple systems. If someone wants to learn how to load data from JSON file or REST API to SQL Server (or other RDBMS systems e.g. Oracle, MySQL) go through the JSON / REST API to SQL Server