Power Bi-Custom Connector-Blank File Method
Method 1: Blank File
Step-by-Step Instructions
Generate the Report:
- Follow the respective guides to generate your report.
Download the .mez File:
- Access to the .mez file is provided to paid users. Download the file.
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
.
![](https://desk.zoho.eu/galleryDocuments/edbsne001f023e61b326fc4a2bc4d1624b59e1f2ebe4bea7879dd48465f03fd37d7d450633daf832ceefdd178dc8d7457852d81fa78750e5b67d160b8e248a3269845?inline=true)
Paste the .mez File:
- Place the downloaded .mez file into the
Custom Connectors
folder.
![](https://desk.zoho.eu/galleryDocuments/edbsne001f023e61b326fc4a2bc4d1624b59e2db4955bdeb1f382d15e29d508dd2611cbb17474b9fa48152424564e0832bc38fa2b8047fd86e9a218aff12809b79ddf?inline=true)
Open Power BI Desktop:
- Launch Microsoft Power BI Desktop.
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".
Authenticate:
- In the Bearer Token dialog box, paste the Bearer Token copied from the Accounting.BI Connectors tab.
Enter URL:
- In the following dialog box, paste the URL for the endpoint report you are looking for.
![](https://desk.zoho.eu/galleryDocuments/edbsne001f023e61b326fc4a2bc4d1624b59e7498faa789992e34c7f94f7f1856d73aeb685cf6ebf08f87bb55c4faaec159fb48650848b75030db70fb1a27da8e7984?inline=true)
Invoke the Data:
Transform Data:
- Click on the double-headed arrow on the rows and select
Expand to New Rows
.
![](https://desk.zoho.eu/galleryDocuments/edbsne001f023e61b326fc4a2bc4d1624b59e597b9fdfd5038650d8d583c04991e0b2b3430515e7222f7a7a66f0ca2782a1924f12ffa0581adc28f763bc151c2577ba?inline=true)
- Click on the double-headed arrow again and click
OK
.
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 ...