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:
- The details of a MYOB ODBC connector
- A method of parsing my MYOB credentials through an Excel data link
- A work around to obtain an access token without creating a custom built interface so that I can utilise the MYOB API
- A recommendation for a well priced 3rd party MYOB connector
Thanks,
Steve