- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Senior BI Consultant
Information Workers
http://www.iwco.co
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Senior BI Consultant
Information Workers
http://www.iwco.co

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-26-2024 05:52 AM | |||
09-20-2023 01:36 AM | |||
02-16-2024 06:45 AM | |||
06-02-2024 11:01 PM | |||
07-01-2023 03:57 AM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
9 |