Connect Power BI to WooCommerce, quickly and free

This tutorial explains how to analyze orders from WooCommerce (WordPress) in Power BI, without any paid tool.

How to do it?

Download and save connector

From here:

https://github.com/migueesc123/WooCommerceConnector

download this file:

WooCommerce.mez

and save it here:

…\Documents\Power BI Desktop\Custom connectors

If you don´t have any, create it.

Power BI Desktop setup

In Power BI Desktop allow this (and pray for nothing bad happens:)

Use connector

In WooCommerce create the keys:

In Power BI new connector appears:

Fill in the info:

Paste the keys:

And from now it´s obvious: