MYOB Accountright Premium ODBC not working

[alim]

Hi All,

I am trying to connect MYOB accountright Premium via odbc. I am able to extract data into EXcel and Access but when I try doing it through Powerbi Desktop. I recieve the following Error:

DataSource.Error: ODBC: ERROR [01000] [MYOB ODBC]Not in use - Reserved for Unicode

Please Provide suggestions.

Thanks in advance.

Regards

Ali

[v-yuezhe-msft]

Hi @alim,

I am not familiar with MYOB AccountingRight. In your scenario, have you successfully created a ODBC DSN for MYOB AccountingRight? If so, do you test connection in ODBC administrator?

Besides, to connect to AccountingRight from Power BI Desktop, try to use the web connector to consume MYOB data with MYOB AccountingRight API and check if it is successful.


For more details, please review the following similar blogs.

Using MS Excel to connect
Getting Started

Thanks,
Lydia Zhang