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 E...
Forum Discussion
Hi Everyone,
Is anyone aware of the direct MYOB API link to connect to PowerBI.
Hi cliftonbathroom,
MYOB doesn’t currently have a direct, built-in API connector for Power BI. However, you can still connect MYOB data to Power BI using third-party connectors like cdata.com. Hopefully, another developer in the community can jump in with more specifics, but if you need more help, don’t hesitate to reach out to the support team via developer.myob.com.
Cheers,
Princess
Cdata is an option, although I lost hours trying to get it to work with no success. The connection kept saying it was connected but I would get authorisation errors when I tried querying the data. The cdata support wasn't able to help either. I ended up exporting the data and pulling the data into an excel model through Power Query. It wasn't a great time.
