Are you encountering the error message: "Formula.Firewall: Query 'Query1' (step 'FinalResult') is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination." when using Power Query? This article provides a straightforward guide for Acc.Bi users on how to resolve this common issue when connecting Microsoft Excel to Xero via AccountingBi using Power Query M code.
Are you confused about the differences between a Financial Controller and an FP&A professional? While both roles are essential in managing a company’s finances, they serve distinct purposes. In this article, we’ll break down the key responsibilities of each role, highlighting their unique contributions to a company’s financial health and strategy. Whether you’re looking to advance your career or optimize your finance team, understanding the contrast between these roles is crucial for long-term success.
This article addresses a challenge encountered when consolidating reports across multiple Xero organisations in different regions. Here, we'll explore the issue with "Display Values" in Xero's Profit & Loss and Balance Sheet reports and how to rectify it.
Are you confused about the "Standard Layout" setting in the Xero Reports API? This feature used to control how profit and loss reports looked, but it's changed. Let's explore what it does now.
This guide will walk you through installing a custom connector for Power BI, specifically the Accounting BI connector which allows you to connect your Xero data to Power BI for analysis.
This article explains the different statuses you might encounter when running reports in Accounting.BI. Understanding these statuses can help you know what's happening with your report and when to expect the results.
At AccountingBi, we understand that our clients trust us with their sensitive data. That is why we are constantly improving our data security to create a secure space that protects our(including clients’) data from cyber threats.
