Power Bi-Custom Connector-Blank File Method

Power Bi-Custom Connector-Blank File Method

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.



    • Related Articles

    • Power Bi-Power Query-Blank File Method

      a) Using a Blank File Step 1: Generate Reports First, generate the Profit and Loss and Balance Sheet reports by following the respective guides. Step 2: Access Power Query Open Power BI Desktop. Go to the Home tab and click on Get Data. Select Blank ...

    • Excel-Power Query-Blank File Method

      Method 1: Using a Blank File Step 1: Generate Reports First, generate the Profit and Loss and Balance Sheet reports by following their respective guides. Step 2: Access Power Query Open Excel and go to the Data tab. Click on Get Data, then select ...

    • Excel Add-in-Blank File Method

      Method 1: Using a Blank File Step 1: Install the Excel Add-in For Single Users: Open Excel Desktop or Excel Web. Navigate to the Home tab. Go to the Add-in section and click on "+More Add-ins". Search for "Accounting.Bi" and install the Accounting Bi ...

    • Power Bi-Custom Connector-Template Method

      Templates: Step-by-Step Instructions Access Template Section: Visit the template section at https://accounting.bi/template-dashboards/. Build Your Template: Contact support at support@accounting.bi to build your template from scratch or to connect ...

    • Power Bi-Power Query-Template Method

      a) Using Templates Step 1: Access Templates Visit the https://accounting.bi/template-dashboards/. Step 2: Connect to Support Contact support at support@accounting.bi to build your template from scratch or to connect your organization's data in the ...