Forum Discussion

Tacity1's avatar
21 days 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

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator

    Hi Tacity1,

     

    Hopefully another developer in the community can get you a response soon, otherwise feel free to reach out to the support team via developer.myob.com.

     

    Regards,

    Sai