Forum Discussion

exceldoktor's avatar
exceldoktor
New Member
5 years ago

WooCommerce Rest API

Hi Community, I have a Power BI model, where I on a weekly basis creates a number of csv files from woocommerce, that I import to Power BI. I would like to automate that process. I have the po...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi exceldoktor,

I have two ideas to handle with your requirement, you can take a look at the below scenarios if they helped.

#1, Sync data to specify path then use power bi to get data.

1. Create a flow or other type of schedule to sync the woocommerce data to a local device or cloud server(SharePoint/one drive).

2. Use power bi folder connector(local) or web connector(cloud service) to get data from these paths.

Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Docs

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

#2, Create a list of key values and use web connector to loop these values with the rest API.

Loop through Multiple Web Pages using Power Query - Adatis

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

Regards,

Xiaoxin Sheng