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

Anonymous
2023-09-29T11:15:32.8566667+00:00

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!

Thanks

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
    2023-09-29T17:23:29.63+00:00

  2. AniyaTang-MSFT 12,331 Reputation points Microsoft Vendor
    2023-10-02T01:41:47.58+00:00

    Hi @Tavares, Miguel

    You can also refer to this article: https://www.oraylis.de/blog/2016/how-to-use-power-bi-as-data-source-in-ssis.

    Best regards,

    Aniya


  3. Anonymous
    2023-10-03T13:01:49.8633333+00:00

    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