SSIS adapter for Power BI REST api
You can find all information related to Power BI REST api here: https://msdn.microsoft.com/library/dn877544
For now, the api is very limited. It only allows you to:
- Create new DataSet and Tables in it.
- Get list of all DataSets.
- Insert new records into tables.
- Remove all records from Tables.
##Type mappings
| string | double | Boolean | Int64 | Datetime |
|---|---|---|---|---|
| DT_STR | DT_R4 | DT_UI1 | DT_UI2 | DT_DBTIMESTAMP |
| DT_WSTR | DT_CY | DT_I1 | DT_I2 | DT_DATE |
| DT_NTEXT | DT_R8 | DT_BOOL | DT_UI4 | |
| DT_GUID | DT_I4 |
| | | DT_UI8 | |
| | | DT_I8 | |
How to use this adapter, please refer to the blog post here: http://ioi.solutions/ssis-adapter-for-power-bi-rest-api/
##Update 26/04/2015
- Added new Parameter to clean rows in a table before insert.