PBIPushData is an SSIS Destination Component to push data to tables on Power BI Service.
Works with both free and Pro Power BI Service.

Power BI APIs have restrictions for pushing data to Power BI service. PBIPushData component along with our PBIHelper makes it possible to push data to Power BI service.

Best of all, both are offered free!

  •  Goto : https://dev.powerbi.com/apps
  • Login using your Power BI account
  • Complete section “Tell us about your app “
      Example:
      • App Name: PBIPushData
      • AppType : Choose Native
      • App URL : https://login.live.com/oauth20_desktop.srf
  • Complete section “Choose APIs to access”
  • Complete the registration.

NOTE: Save generated ClientID. This is required for both PBIPushData SSIS Component and PBIHelper application.

  • Sign in to your Azure account: https://manage.windowsazure.com/
  • Click on option Active Directory.
  • Click on your native application (registered in Step 3) to manage.
  • Click on configure to provide permissions.

NOTE: If your application is not listed, add your application and provide permissions.

Create Datasets and Tables to be used with Demo package.

1. Logon : Provide Power BI credentials and Save.
                Select the account and click connect.

2. Click on button New Dataset.

3. Enter Following information and click on Create Dataset & Tables.

           Dataset Name: HR

           Click on [+] in Group Tables. Define table Departments

           Click on [+] in Group Columns. Define following columns.
Column Name Data Type
DepartmentID Int64
Name String
GroupName String
ModifiedDate DateTime
Click on button Create Dataset & Tables
Repeat the process to create dataset Sales.
           Dataset Name: Sales

           Click on [+] in Group Tables. Define table SalesDetails

           Click on [+] in Group Columns. Define following columns.
Column Name Data Type
SalesOrderID Int64
SalesOrderDetailID Int64
CarrierTrackingNumber String
OrderQty Int64
ProductID Int64
SpecialOfferID Int64
UnitPrice Double
LineTotal Double
ModifiedDate DateTime
Download and install SSIS Destination Component PBIPushData.
SQL 2012
SQL 2014
SQL 2016

Reconfigure Demo package.
Open the demo package.
       Open the DFT DFT_PUSH_SALES_TO_POWER_BI_DS_SALES.
       Open the component PBI_PUSH_SALES_DETAILS_TO_DS_SALES.
       Enter PBI Credentials on tab Connection Settings.
       Map to Dataset Sales & table SalesDetails in tab Column Mappings.

       Open the DFT DFT_PUSH_SALES_TO_POWER_BI_DS_SALES.
       Open the component PBI_PUSH_HR_DEPARTMENTS_TO_DS_HR.
       Enter PBI Credentials on tab Connection Settings.
       Map to Dataset HR & table Departments in tab Column Mappings.
Close Menu