Method 1: Blank File

Step-by-Step Instructions

1. Generate the Report:

   • Follow the respective guides to generate your report.

2. Download the .mez File:

   • Access to the .mez file is provided to paid users. Download the file.

3. Create Necessary Folders:

   • Navigate to Documents from "This PC".
   • Create a folder named Power BI Desktop.
     
     
     
   • Inside the Power BI Desktop folder, create another folder named Custom Connectors.
        

4. Paste the .mez File:

   • Place the downloaded .mez file into the Custom Connectors folder.
     
        

5. Open Power BI Desktop:

   • Launch Microsoft Power BI Desktop.

6. Import Data:

   • Click on the Home tab, then select Get Data from the dropdown menu.
        
     
   • Click on More and search for "Acc" or "Xero".
     
     
     
   • Select the Custom Connector and click on "Connect".

7. Authenticate:

   • In the Bearer Token dialog box, paste the Bearer Token copied from the Accounting.BI Connectors tab.

8. Enter URL:

   • In the following dialog box, paste the URL for the endpoint report you are looking for.
     
        

9. Invoke the Data:

   • Click on Invoke.
     
     
     

10. Transform Data:

    • Click on the double-headed arrow on the rows and select Expand to New Rows.
      
         
    • Click on the double-headed arrow again and click OK.
      
      
      

11. View Data:

    • Your data will now be displayed accordingly.