Forum Discussion

exceldoktor's avatar
exceldoktor
New Member
4 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
4 years ago

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's avatar
Histos
New Member
4 years ago

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's avatar
    CoderZen08
    Helper V
    2 years ago

    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