Load the data by using power query to SQL database

[Anonymous]

Hi Team,

I have created report by connecting web API as data source. 

Now need to create SSIS package by using power query to load the data in to SQL Database.

and also how to call power query function in SSIS level.  Could you please anyone help me on this

.

Thank you in advance.

[dax · Accepted solution]

Hi @Anonymous , 

If you want to use power query in SSIS, I think you could try to refer to power-query-in-ssis  and power-query-source-for-sql-server-integration-services  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.