As Shopify has limited exporting options, to get data from the platform, you need a special tool like Power BI Connector
by Alpha Serve
. It helps to extract only the data you need from Shopify and transfer it directly to Power BI in an understandable format. You can also set up scheduled automated updates and have the required data in the time you need it.
Power BI Connector was developed with users not having any special skills in mind, and you need any additional training to start using it. You can install the app here