Link Excel Power Query to worpress website (ODBC ect)

[gazmoz17]

Hi,

Im struggling to find an available ODBC connector to Wordpress? I have a working Shopify solution. CData is too much money Ive been hugely misled by Devart and wasted a lot of time. It seem via their connector I can t connect to Products table in Wordpress.

Single Use Case

So can create a control:

Track our product website products are matching true live sales price in our accountancy system. I already have a connector to power query from accountancy system. So I wish to create a new query with wordpress connector and then merge the queires only highlighting diffs etc. Would also be handy just as a method of highlighting what products our published to our website and which arent.

From Devart (maybe it's my understanding or a limitation of my Wordpress template)

Mnay Thanks
Gareth

 

[Matt Allington]

I wrote this back in 2014

WordPress Reporting using Power Query

It occurred to me that I could extract the data from an underlying WordPress Database using Power Query, and then create a report in PowerPivot, and you can

exceleratorbi.com.au

i can’t be clear what your errors are, but the approach linked worked for me.

 

[gazmoz17]

Hi Matt,

Thats great thanks and looks just what I’m looking for

Currently very basic website so only need product data, but in the future (post web rebuild) this will be even more useful.

Thanks