Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →Create WooCommerce Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
The CData Power BI Connector for WooCommerce seamlessly integrates with the tools and wizards in Power BI, including the real-time data workflows on PowerBI.com. Follow the steps below to pull data directly into DataFlows on PowerBI.com and use the Power BI Gateway to configure automatic refresh.
Create a DSN
Installing the Power BI Connector creates a DSN (data source name) called CData Power BI WooCommerce. This the name of the DSN that Power BI uses to request a connection to the data source. Configure the DSN by filling in the required connection properties.
You can use the Microsoft ODBC Data Source Administrator to create a new DSN or configure (and rename) an existing DSN: From the Start menu, enter "ODBC Data Sources." Ensure that you run the version of the ODBC Administrator that corresponds to the bitness of your Power BI Desktop installation (32-bit or 64-bit).
WooCommerce supports the following authentication methods: one-legged OAuth1.0 Authentication and standard OAuth2.0 Authentication.
Connecting using one-legged OAuth 1.0 Authentication
Specify the following properties (NOTE: the below credentials are generated from WooCommerce settings page and should not be confused with the credentials generated by using WordPress OAuth2.0 plugin):
- ConsumerKey
- ConsumerSecret
Connecting using WordPress OAuth 2.0 Authentication
After having configured the plugin, you may connect to WooCommerce by providing the following connection properties:
In either case, you will need to set the Url property to the URL of the WooCommerce instance.
With the data source configured, follow the steps below to load data from WooCommerce tables into your DataFlow.
Follow the steps below to configure the gateway on your machine:
In the Connectors step, choose a folder where the gateway will look for the CData Power BI Connector. This article uses C:\Users\PBIEgwService\Documents\Power BI Desktop\Custom Connectors\. Copy the .pqx files for the CData Connector (found in C:\Users\USERNAME\Documents\Power BI Desktop\Custom Connectors\) to the folder you configured.
NOTE: The account configured for the service (NT SERVICE\PBIEgwService) needs to be able to access the folder chosen for the gateway. If needed, you can change the service account in the Service Settings section of the gateway installer.
Refresh your dataflow to have the most up to date data.
Pulling WooCommerce Data Directly Into Your Dataflow
Set Up the Power BI Gateway
Set up Power BI Online for a Dataflow
If you would like to manage the users that have access to this data source, you can go to the Users tab.
Set up your Dataflow and pull the WooCommerce data
Enter your DSN name in the ODBC connection string section, dsn=CData Power BI WooCommerce. Choose your gateway and set the authentication type to Anonymous.
If you want to make any changes to the query, you can right click on the query and click on Advanced Editor.
Configure Data Refresh on PowerBI.com
At this point, you will have a Dataflow built on top of live WooCommerce data. Learn more about the CData Power BI Connectors for WooCommerce and download a free trial from the CData Power BI Connector for WooCommerce page. Let our Support Team know if you have any questions.