I've been comparing tools and for the price, ease of use, functionality, and scalability, this is the best I've come up with for a medium company running Shopify.
The plan is to setup a pipeline using Google Cloud with various off the shelf and custom connectors, and use Microsoft Power BI for it's capabilities above and beyond Data Studio, including additional chart types, integration into Teams, Office 365 in general, and just a better collaborative experience. With the Pro per user license, it doesn't even need to be a Microsoft shop to make sense. BigQuery makes the most sense to me given it's generous free tier, integration with Sheets, GA, scalability, etc.
Does anyone have experience using BigQuery with Power BI?
Are there any pros or cons based on experience you would share?