WooCommerce Rest API

[exceldoktor]

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 possibility to buy a process, that does all of that for me, but for $35 per month and then I can not control anything the way I want it.

Can anyone help with instructions on how to set this up myself. 

it seems like an easy thing to do, if you know how to (after all it is just a few csv files that should be connected (as an alternative), but it would be great to know the process as in the future I would like to get my facebook as well as my mailchimp account connected as well.

best regards
Jørgen

[Rose__123]

Hi Jørgen
Did you find a solution?

[exceldoktor]

hi Rose,

I know it is a long time since you asked the question. No I never solved the problem. So far I have been copy and pasting data, which does not work very well.

regards
Jørgen

[v-shex-msft]

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

[exceldoktor]

I would prefer a dataconnector directly from WooCommerce, but if nothing else shows up, I will be looking seriously into the instructions you did send me.
Hopefully there is a direct solution and I can see that it is possible to create a token in WooCommerce, that I should be able to connect to.
regards
Jørgen

[Anonymous]

Jørgen,

One way you could go about this would be to setup a Python script that generates those CSV files for you on a schedule. Just have it update/override the same file, or you can potentially have it email or upload the file to sharepoint and the you can have multiple.

https://pypi.org/project/WooCommerce/

Here's a library for Python that supports connecting to the API for woocommerce. Just make sure that wherever you save the file it is at the same path on the gateway if you are using PBI Service.

[Histos]

Thank you, that sounds very interesting and I will try it.

But is not possible to connect Power BI to the Woocommerce's API??

[CoderZen08]

Hello @Histos you can export data directly from Woocommerce API to Power BI instead of using CSV files. I connect my Woocommerce data using windsor.ai and I don't need to do any manual or copy/paste work