Forum Discussion

THEG72's avatar
THEG72
Helper V
9 years ago

API connector and POWER BI integration

Hi Power BI users,   Does anyone know, about how the new version of MYOB Accountright 2016.3 (SQL) can hook up to power bi.???   The older version Accountright Premier/Enterprise uses a 32 bit OD...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

THEG72,

32 bit Power BI Desktop accepts 32 bit ODBC connection. You would need to contact MYOB support about that why they don't provide ODBC driver for MYOB AccountRight 20xx.


Regards,
Lydia Zhang

THEG72's avatar
THEG72
Helper V
9 years ago

Hi Anonymous

 

I tried the 32 bit version with odbc driver from Myob but i get an error but it does seem to find all the tables.

 

This my dsn

 

i am using 32bit version of Power BI....

on loading the account table i get error

 

I click load and get error below, :unable to read beyond the end of stream.."

 

heres theoutput log

https://1drv.ms/t/s!AnS2TMz05ePlgQXCISetoGDBXy0M

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    THEG72,

    Do you create DSN for MYOB Accountright 2016.3 using old version of ODBC driver?

    Regards,

  • THEG72's avatar
    THEG72
    Helper V
    9 years ago

    No, this is for the Accounting Premier older version as the ODBC 32bit works fine on this. But i get the error shown previously when trying to connect..