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

Hi THEG72,

Please review the following blogs about consuming MYOB data with MYOB AccountingRight API via Web connector. In Power BI Desktop,  you should enter URL like: http://[IP ADDRESS OF COMPUTER TO ACCESS]:8080/accountright/GUID/XXXX/XXXX/?api-version=v2&format=json.

Getting Started
Using MS Excel to connect

Thanks,
Lydia Zhang

THEG72's avatar
THEG72
Helper V
9 years ago

Anonymous

 

Thanks for the information but that information is very limited and not really understandable in how you get from those steps into Power BI....

 

For example,  

 

1. http://localhost:8080/accountright/ (It displays the myob data files and prompts for MYOB credentials login..so far ok)

2. It then Lists AbsoluteUri which are links to tables like Account, Contact, GeneralJournal endpoints..

3. I click on Account URI and get alist of accounts

 

Per info, I can use the version 2 endpoints by adding as follows;

http://localhost:8080/AccountRight/91a5c87e-884f-42f5-b4d5-0f924164e116/Account/?api-version=v2

 

 

Ok endpoint is retrieved and i go to open Excel..and get web data...

 

I paste the end point in and can add a formatting command...&format=html 

http://localhost:8080/AccountRight/91a5c87e-884f-42f5-b4d5-0f924164e116/Account/?api-version=v2&format=html

It reconfirms Login crenditials and then displays data

 you can also use &format=json..too i think

 

 

 i click import and the base of the screen shot...and then nothing happens computer just crashes in Excel....

 

MYOB states "This is just step one in a set of tutorials focused on MS Excel and our MYOB AccountRight Live API, come back soon for more exploratory MS Excel Tutorials"

 

This hasnt been updated for a long time so surely there is an easier way.....

 

Hopefully someone in know can assist!!

 

 

 

 

 

Is Power BI not setup to connect to this data source easily like other packages ? with the old version (using 32 odbc) you can connect tables to Excel, build a model which Power BI connects ti easily...

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi THEG72,

    What is the result when you enter http://localhost:8080/AccountRight/91a5c87e-884f-42f5-b4d5-0f924164e116/Account/?api-version=v2&format=json in "Get Data->Web" entry in Power BI Desktop? 


    In Power BI Desktop, there is no built-in connector for MYOB accounting, you can submit an idea in this forum about this issue.

    Moreover, as far as I know, the new 20xx versions of MYOB Accounting no longer have ODBC, you are not able to create DSN for MYOB Accounting and connect to the ODBC data source in Power BI Desktop.

    Regards,
    Lydia Zhang

    • 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?