You answer:

Hello! I think that there are many solutions for working with Shopify on the Internet, but, of course, not all of them are really high quality. In general, I can recommend Power BI Connector to you, click this link https://www.alphaservesp.com/products/shopify/power-bi/ to read more about this solution. I think this is a great business opportunity.