API connector and POWER BI integration

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...