Forum Discussion
Power BI and Dataflows
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...
Hello, going for the PBI dataflows option would not be easy from what I see because both Quickbooks and Shopify would need to have native connectors to PBI, which I guess they don't at the moment. Using a cloud storage like Azure data lake could be useful but you'll need to make the connection from the sources to Azure to make all the ETL process in there, the thing is doing this integration would require some development on your side I guess. As a workardound, I would suggest you to use an external tool to easily export data from both Quickbooks and Shopify into Azure SQL. I've used windsor.ai to make this integration in the past as they offer both connectors