Migrate power query to SSAS or SSIS?

[Anonymous]

Hi everyone, currently we are having some transformations and data manipulations using the query designer in power bi, so our next move is to automate these manipulations through SSIS, so what's the better approach should we either:

1- Migrate to SSAS then deploy to the analysis services in SSMS, and then import as a source in SSIS.

or

2-We migrate directly to SSIS using the newly added source component ( Power Query Source ).

[v-piga-msft]

Hi @Anonymous ,

I'm afraid this problem is most related with SSIS or SSAS, you 'd better get the most professional help from here and it seems that you have got the answer from this similar thread.

If you still need help about Power bi, feel free to ask.

Best Regards,

Cherry