Forum Discussion

Tacity1's avatar
Tacity1
Member
1 year ago

MYOB PowerBI/Power Query connection

Hi All,

I have seen some conflicting information on this so would love to hear exactly what the situation is from someone who knows.

I used to use an ODBC link to access the back end of MYOB with Excel. It appears this is no longer supported and I now need to subscribe to a 3rd party software like CData. Is this correct?

A lot of Chat GPT responses are telling me to access the database via the MYOB API but this requires authenticating with https://secure.myob.com/oauth2/v1/authorize to retrieve an access token so this does not appear to be viable without a custom build interface. 

 

Given that all I am looking for is to build Power BI reports or Excel reports, I am looking for any of the following:

  1. The details of a MYOB ODBC connector
  2. A method of parsing my MYOB credentials through an Excel data link
  3. A work around to obtain an access token without creating a custom built interface so that I can utilise the MYOB API
  4. A recommendation for a well priced 3rd party MYOB connector

Thanks,

Steve

Power BI

11 Replies

Show More
  • MAC221267's avatar
    MAC221267
    Cover User
    5 months ago

    Ok for local databases with the Myob Addon Connector running on your pc, you just need some simple M code inside Power Query advanced editor, and use basic authentication with username and password in Power Query.

     

    For online access you can backup the file to desktop open and access the same way.

     

    If you want real time online data you have to follow the MYOB API instructions, by using a program language. Download and save the database you want to a txt file, the. access it through Power Query. I built my own api connector with Excel VBA, so everything is done inside excel. This was very complex, and if I’m eventually going to share it will be through Github. The reason I haven’t yet, is the amount of queries i’ll receive will end up costing me 50 hours week explaining.

     

    For the desktop files i posted the solution a few years ago.

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.