Martin has attended:
Power BI Modelling, Visualisation and Publishing course
Intergrations
Good Morning Jens,
It was lovely to meet everyone over the past few days.
I want to start with one of our subsidiaries for data analysis using PowerBI. They use Shopify, where most of the data is stored. Can you advise how I can get the data? Our owners are dubious about Integrations, so I think exploring other options would be better initially.
So far - I've explored Get Data > Web but
Thank-you
Martin
RE: Intergrations
Good morning, Martin!
I am happy that you had some good days and thank you for the nice feedback. I am happy that you found the course useful.
It's great that you're looking to leverage Power BI for data analysis. Since your subsidiary uses Shopify, there are a few ways to get the data into Power BI. Here are some options you can consider:
1. Using Power BI Connector for Shopify
This is a dedicated app that simplifies the process of connecting Shopify to Power BI. It allows you to import data directly from Shopify into Power BI for analysis. You can find this app on the Shopify App Store.
2. Using Web Data Connector
Since you've already explored the Get Data > Web option, you can use it to pull data from Shopify's API. This method involves creating a custom query to fetch the data you need. Here’s a brief outline:
Go to Get Data > Web.
Enter the URL for the Shopify API endpoint you want to access.
Authenticate using your Shopify credentials.
Transform and clean the data as needed in Power BI.
3. Using Third-Party Tools
There are third-party tools like Catchr that can help you export Shopify data to Google Sheets or directly to Power BI. These tools often provide templates and step-by-step guides to make the integration smoother.
4. Manual Export and Import
If integrations are a concern, you can manually export data from Shopify (e.g., CSV files) and then import these files into Power BI. This method is more labor-intensive but avoids direct integration.
Steps for Manual Export and Import:
Export the required data from Shopify as CSV files.
In Power BI, go to Get Data > Text/CSV.
Select the CSV file and load it into Power BI.
Transform and clean the data as needed.
5. Using Data Integration Platforms
Platforms like Zapier or Integromat can automate the process of moving data from Shopify to Power BI. These platforms often provide pre-built connectors and workflows to simplify the process.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
