MYOB PowerBI/Power Query connection

Question

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&nbsp;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.&nbsp;&nbsp;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 connectorA method of parsing my MYOB credentials through an Excel data linkA work around to obtain an access token without creating a custom built interface so that I can utilise the MYOB APIA recommendation for a well priced 3rd party MYOB connectorThanks,Steve

aexley · Answer

Tacity1Hi. Just joined up to the MYOB API developers and saw your question on Power BI. As someone who's been developing with Power BI for about 10 years, I can say that it'll be a highly complex matter to join Power BI directly to MYOB. Power BI can't easily handle the required token refresh. There are different ways to achieve this but require a complex bit of setup and configuration. Unfortunately, don't know of any third parties who've developed an integration to Power BI.

Regards,

Andrew

isaiah_c · Answer

Hi Tacity1,
&nbsp;
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.
&nbsp;
Regards,
Sai

tacity · Answer

Hi Andrew, Is there a way to talk to you about this through DM?

aexley · Answer

HiTacity1 . Unfortunately I don’t think the forum has a DM feature. But if you’d like to I’ve shared my email address here if you want to discuss further. https://privnote.com/lVbsJl2M#NNBTtI03d

tacity · Answer

Got it, thanks

Forum Discussion

MYOB PowerBI/Power Query connection

Looking for something else?

Related content

Query Regarding Connecting PowerBI to MYOB AccountRight Data

Connection Error

Invoice query

BAS submission query.

Invoice save query & notes

Not Connecting

Connection Error

Card File Query