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
THEG72's avatar
THEG72
Helper V
9 years ago

HI Anonymous

 

Yes the new version uses an SQL database and has an API to connect to..but i havent seen any instructions on how this works..

 

The older version uses a 32bit ODBC driver which i used to connect in Excel and extract tables...Power BI doesnt do 32bit ODBC does it?

 

WHen i enter the connection into Power bi i get the following:

I am not sure how i can retreieve the items in the List...as its not listing the tables as such...But i can see records

 

Is there a different method to access the files stored as json format?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

THEG72,

In your scenario, you are not able to use ODBC entry in Power BI Desktop to connect to your data source as you are unable to create DSN for your MYOB Accounting. As far as I know, you can only use the API to get data from MYOB in Power BI Desktop.

Regarding to your JSON source in Power BI Desktop, please follow the instructions in the following similar thread and blog to get the data.

https://community.powerbi.com/t5/Desktop/Stuck-with-quot-nested-quot-records/td-p/65865

https://blogs.msdn.microsoft.com/lukaszp/2016/04/17/working-with-json-data-in-power-bi-desktops-query-tab/

Regards,
Lydia Zhang

  • THEG72's avatar
    THEG72
    Helper V
    9 years ago

    HI Anonymous

    Thanks for your time in replying to my request.

     

    You are right the API is for the new version of MYOB AccountRight 20xx...I will examine your reference to how to access the data from the json export...

     

    With the older version of MYOB (Premier), I am able to create a DSN connetion to my MYOB Accounting Premier File as shown in the link below:

     

    http://help.myob.com/wiki/display/supar/Creating+a+Data+Source+Name+%28DSN%29+and+test+connection+in+ODBC+Direct#expand-DSNConnection

     

    Its a 32 bit MYOB ODBC driver the DSN is using for the connection...So i belive the issue is Power BI doesnt accept a 32 bit ODBC connection? Is that correct? it can only do 64 bit?

     

     

     

     

     

     

    • 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