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