You can use the power query source.
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!
Thanks
3 answers
Sort by: Most helpful
-
-
AniyaTang-MSFT 12,421 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
-
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.