MYOB-Power BI Integration using APIs

Question

I need to connect MYOB Account Right to PowerBI.As there is no direct connector,I am planning to connect using APIs. Is it possible? Please help me if someone use the same.

hannah_b · Answer

Hi&nbsp;Jeff_AccAddons&nbsp;
&nbsp;
Thanks for the information that is great to know there is an addon for Power BI and Excel to connect.&nbsp;
&nbsp;
Thanks,&nbsp;
&nbsp;

steven_m · Answer

Hi&nbsp;Lakshmi&nbsp;
&nbsp;
AccountRight 20xx does have an API called the MYOB AccountRight API. Connection to the API allows integration with the AccountRight software and third-party applications.
For more information on the AccountRight API and getting started do check out our Developer Centre.

lakshmi · Answer

Thanks&nbsp;Steven_M&nbsp;. I havechecked with the developer team and tried to view data using postman.&nbsp; I have followed this link&nbsp;https://developer.myob.com/api/accountright/accountright-postman-collection/&nbsp;&nbsp;.I got access token and refresh token. But in the next step when I am trying to list out the company files, Getting below error.{&nbsp;&nbsp;&nbsp;&nbsp;"Errors":&nbsp;[&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Name":&nbsp;"OAuthTokenIsMissing",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Message":&nbsp;"The&nbsp;supplied&nbsp;OAuth&nbsp;token&nbsp;is&nbsp;missing",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"AdditionalDetails":&nbsp;"Header",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"ErrorCode":&nbsp;31002,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Severity":&nbsp;"Error",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"LearnMore":&nbsp;null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;],&nbsp;&nbsp;&nbsp;&nbsp;"Information":&nbsp;"Warning,&nbsp;error&nbsp;messages&nbsp;have&nbsp;not&nbsp;been&nbsp;finalised&nbsp;in&nbsp;this&nbsp;release&nbsp;and&nbsp;may&nbsp;change"}&nbsp;I am not sure what all details I have to give in headers and authorization. Can you help?&nbsp;Thanks in advance.&nbsp;Lakshmi

hannah_b · Answer

Hi&nbsp;Lakshmi (Lakshmi)
&nbsp;
Thank you for reaching out,&nbsp;We often see this error when you are trying to connect to an old essentials company file however the Essentials file has been upgraded to our New platform.
Once the Essentials file has been upgraded to the new platform we need to complete Oauth with the scope of&nbsp;la.global CompanyFile.&nbsp;This will cover Old Essentials, New Essentials and AccountRight. Then in order to pull the company file, we need to use the endpoint&nbsp;https://api.myob.com/accountright/&nbsp;which will pull AccountRight and New Essentials files.
&nbsp;
If this does not resolve the error you can raise a support request with us&nbsp;HERE.&nbsp;

lakshmi · Answer

Hi Hannah_B&nbsp;I got access to the company files in postman. I took free developer access. Will it expire? Because I cannot get the access token now which I was getting till friday.&nbsp;

Forum Discussion

MYOB-Power BI Integration using APIs

Looking for something else?

Related content

Power BI Connect to MYOB Accountright

MYOB AccountRight Plus and POWER BI

Lightspeed integration

Fingerprint integration

Integration with Outlook Failing - System.InvalidCastException

MYOB Zapier Integration

Integration with Microsoft Power Automate

Fergus Integration Error: NoTaxCodeFound