Forum Discussion

maxchrys's avatar
maxchrys
New Member
7 years ago
Solved

Connecting with multiple client MYOB files

I see a lot of potential with the PowerBI service as a value add to clients. I am trialling the product and seem to be able to connect MYOB data with one client data file using the MYOB app. Howe...
maxchrys's avatar
maxchrys
New Member
7 years ago

Hi Lydia,

 

Your recommended process was very useful and allowed me to establish a couple of MYOB client data files in PowerBI.

I am trying to establish a couple more, but am having some issues.

 

In one case, I received an error message as follows, but I do not know how to resolve it:

 

We couldn't import data from MYOB AccountRight
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: Column 'Account.UID' in Table 'TaxCode' contains a duplicate value '2f1a31eb-f700-4ca4-8a61-63d085649e16' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: TaxCode.
Activity ID: 7b0ac896-7151-479f-8fab-cdb1907272f6
Correlation ID: 06925222-23c4-f4fa-7489-584f30356fc1
Request ID: 17373665-5e7e-77bf-b387-f34b459df7ba
Status code: 400
Time: Tue Oct 23 2018 21:08:03 GMT+1100 (AUS Eastern Daylight Time)
Version: 13.0.7055.182
Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net

 

I welcome any advice on how to resolve this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    maxchrys,

    Please check Account.UID column on your MYOB side, make sure the column contains unique values.

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi all,

      Have you managed to combine multiple MYOB companies? So if you have two company files to combine them to get the one company file for that business? Not on a dashboard, so you can see jobs and categories across the two combined companies? 

      I can get one company file in but not sure how to go about bringing in the other?

       

      Thanks