Forum Discussion
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...
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.
Thank you, that sounds very interesting and I will try it.
But is not possible to connect Power BI to the Woocommerce's API??