Forum Discussion
Dataflows as ETL
Hi is there any possibility to use PowerbiService/Platform as whole ETL solution? I have an API, everyday I would like to take data from there and store it in some historical table? Can I do it somehow?
I saw that Dataflows have some Azure Data Lake integration? Or maybe should I use datamart?
1 Reply
Hey kageyoshi777 ,
I recommend using Incremental Refresh for Dataflows: https://learn.microsoft.com/en-us/power-query/dataflows/incremental-refresh
Hopefully, this provides some ideas of how to tackle your challenge.
Regards,
Tom
