Apologies if this is not the right section. I am somewhat new to this fascinating tool and still have to get around all the existing and new capabilities that keep getting released in the blink of an eye.
I would love to be able to extract from Quickbooks Commerce + Shopify + Google sheets, I am almost positive I could do the ETL process using Power Query.
To my understanding, would data flow enable me to connect to the cloud SaaS, ETL them and load to some sort of 'free' azure cloud data lake ? (we currently don't have a Data Lake / Warehouse and I could use this 'test/prototype' to showcase at least one thing that can be done with cloud storage )
To give you a little bit of background currently I got tangled in a painstaking process where I export standard reports from Quickbooks + Shopify, save them on my local drive and then the Power bi model kicks in by loading the folder, and I would very much like not only automate that, but extract data from those softwares that I am currently unable (i.e. in QBC historic inventory costs on every date)
Hope the message makes sense, and thanks everyone for making this forum great.
