How to connect to a Power BI dataflow from SSIS package?


I need to load data from a dataflow that is in a Power BI workspace to an on-prem SQL Server database using Integration Services as the ETL tool.

Is it possible to connect from SSIS to the Power BI dataflow? And which connector(s) can/should I use?

I already installed CDM (Common Data Model) connector from Kingswaysoft so I'm trying to use the CDM Source, but I don't know what type of connection I should use in the CDM Source nor how I should pass the credentials and path (dataflow endpoint) to the dataflow.

Any help would be much appreciated!


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 19,145 Reputation points

  2. AniyaTang-MSFT 12,331 Reputation points Microsoft Vendor

    Hi @Tavares, Miguel

    You can also refer to this article:

    Best regards,


  3. Anonymous

    An eventual alternative solution (similar but more straightforward) would be import the data through excel with power query and then use excel as source in SSIS.

    0 comments No comments