Partner Zone
Partner Zone

Power Pivot

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
5 REPLIES 5
Valued User AccountingPower
179 Posts
Valued User
AccountingPower
Valued User

179Posts

49Kudos

10Solutions

Re: Power Pivot

Hi David

 

I specialise in connecting MYOB to Power Pivot, along with Power BI and Power Query. Contact me at matt@accountingpower.com.au and I can point you in the right direction to get you started.

 

Matt

 

 

Matthew Jones
Contributing Partner DavidFisher
7 Posts
Contributing Partner
DavidFisher
Contributing Partner

7Posts

0Kudos

0Solutions

Re: Power Pivot

Hi Mke

 

Thanks for your continued assistance/persistence.

 

Neither url works.  I'm not sure where I'd find my local ID to replace the blue.

 

Confirming that my file is in the cloud....

 

Regards

David

Ultimate Partner Mike_James
4,245 Posts
Ultimate Partner
New Zealand
Mike_James
Ultimate Partner

4245Posts

1863Kudos

532Solutions

Re: Power Pivot

Hi @DavidFisher, if you open a browser and type in http://localhost:8080/AccountRight/, do you see a list of company files from your local library? If so, you can drill down on any line, and see what resources are available. 

 

However, you will need to modify the URL to add the API version, Eg: http://localhost:8080/AccountRight/3ae6a4e1-4acf-48c5-bde6-40fac54cd4ef?x-myobapi-version=v2.

You will need to replace the blue text with the file id from your own system.

 

Version 2 of the API allows you to access many more endpoints.

 

I'm assuming the file you want to analyse is in a local library. If it is in the cloud, that's another story.

 

 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)
New: S.T.P. Reporting solution for (Aust) v19 users, email for details

Contributing Partner DavidFisher
7 Posts
Contributing Partner
DavidFisher
Contributing Partner

7Posts

0Kudos

0Solutions

Re: Power Pivot

Thanks Mike.

 

It refers to 2013 which makes me think its old.  eg my MYOB files are in C:\Users\[username]\AppData\Local\MYOB\AccountRight.

 

Was I meant to seach for 'installer' or 'api'?  I didn't find a file that I need to run to install the api.

 

I'm still stuck I'm afraid. 

 

 Regards

David

Ultimate Partner Mike_James
4,245 Posts
Ultimate Partner
New Zealand
Mike_James
Ultimate Partner

4245Posts

1863Kudos

532Solutions

Re: Power Pivot

Hi @DavidFisher, this documentation has some basics to get you started:

 

http://developer.myob.com/api/accountright/tips-tricks-tutorials/ms-excel/connect-ms-excel-myob-acco...

 

 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)
New: S.T.P. Reporting solution for (Aust) v19 users, email for details

Contributing Partner DavidFisher
7 Posts
Contributing Partner
DavidFisher
Contributing Partner

7Posts

0Kudos

0Solutions

Power Pivot

Hi all

 

I'd like to get started with Excel Power Pivot and AccountRight 2018.4 cloud. 

 

Does anyone know what is needed to connect Excel Power Pivot to AR? 

 

eg.  Do I need an API?  

 

Thanks in advance

David

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post