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 withhttps://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
