What to do when I get an error 'Exception of Type 'microsoft.mashup.engine.interface.resourceAccessForbiddenException' was thrown.' when using PowerQuery to access an API?

September 29, 2022

Cause of the error

Non- IT Person Explanation 

When using the Accounting.BI system to Excel or PowerBI the error below usually means your Bearer Token (aka the password for our API) has changed / needs updating in PowerQuery. 

'Exception of Type 'microsoft.mashup.engine.interface.resourceAccessForbiddenException' was thrown.' 

Note – for security we periodically update our Bearer Tokens. Get in touch for more information on how to manage with when refreshing your management accounts in Excel or PowerBI. 

 Technical Explanation 

The Accounting.BI API uses something called HTTP parameters to allow you to access your Xero, Sage, QuickBooks, Zoho Books, or NetSuite data via PowerQuery. The authentication method for our API includes a Bearer Token that needs to update periodically via the Advanced Query Editor in PowerQuery. 

Whilst this article is for users of Accounting.BI, the steps below should allow most users to resolve the error 'Exception of Type 'microsoft.mashup.engine.interface.resourceAccessForbiddenException' was thrown.' when using PowerQuery to access an API that uses HTTP parameters for their authentication. 

Step by step Guide to solving the error 

To solve this error, please follow the following steps: 

  • Click OK under the popup notification.

Fixing Bearer token error

  • Right-click the Refresh icon. 

Fixing bearer token error

  • Select Edit from the drop-down list. 

Bearer token error in API - how to fix the problem

  • Click the Advanced Editor tab. 

Bearer token error solution

  • Go back to AccountingBi and copy the correct bearer token. 

AccountingBi bearer token

  • Click Done. 

Solving bearer token error

  • Replace the old bearer token with the new one - copy and paste the new bearer token over the old one. Start from the first letter after Bearer and the space, and finish with the last letter before ". Then click the Done button.  

Bearer token correction

  • Click Close & Load. 

Close & Load

 

Check out the video explanation of the above steps below.

learn more

Why is PowerBI important for Accountants?

As an accountant, you may find yourself referring to multiple sources to track the performance of your client’s cash flow, profitability, business trends and even bookkeeping cycle. What if you could access those results and comparisons automatically refreshed, on-demand, from your tablet, smartphone, PC, or even wearable device? Business intelligence and data visualisation systems can provide accountants with – the critical data and organisation summary in a custom format in one (or more) visuals or a dashboard. One of these powerful business intelligence tools is PowerBI.
READ MORE

Power BI: What is DAX?

DAX (Data Analysis Expressions) is a formula expression language developed by Microsoft to interact with data in different analysis services and visualisation tools platforms like Power BI, PowerPivot and SSAS tabular models. DAX can seem familiar to competent excel users as the language uses similar formulas and expressions.
READ MORE

How to connect your Xero account(s) to AccountingBi

This guide will walk you through two methods for connecting your Xero accounting software to AccountingBi
READ MORE

How to call your profit and loss account reports from Xero to AccountingBi

We have outlined a step-by-step process of calling your profit and loss report data from your Xero account to AccountingBi - article and video.
READ MORE

How to call the balance sheet reports from Xero to AccountingBi

We have outlined the steps of calling balance sheet reports from Xero to AccountingBi in a video (watch below) and an article.
READ MORE

How to connect Microsoft excel to Xero through AccountingBi

This video and article provide steps for connecting Xero to PowerBi through AccountingBi. It assumes that you've already pulled the Xero API from accounting BI for your various reports.
READ MORE
1 2 3 5
READ MORE
Accounting.bi - Business Intelligence Software
Copyright © 2023 Accounting.bi is a brand owned and operated by Accounting SQL Limited, incorporated in the United Kingdom. ​
Terms & Conditions - GDPR