How to Connect Sage Intacct to Power BI

Bringing your Sage Intacct financial data into Power BI is the key to creating comprehensive reports and dashboards that tell the full story of your business performance. This guide will walk you through the process, covering several methods so you can choose the best one for your technical skills and business needs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect Sage Intacct to Power BI?

While Sage Intacct has powerful built-in reporting features, connecting it to Power BI unlocks a new level of analysis. It allows you to move beyond standard financial statements and build truly dynamic, interactive visualizations that reveal the "why" behind the numbers.

Here are the primary benefits of this integration:

• Centralized Data: Combine your financial data from Sage Intacct with operational data from other platforms. Imagine a single dashboard showing your sales pipeline from Salesforce, marketing campaign spend from Google Ads, and the resulting revenue from Intacct. This provides a holistic view of your business health.
• Advanced Customization: Power BI offers almost limitless customization. You can create precisely the types of charts, graphs, and tables you need, formatted with your company’s branding, to track the metrics that matter most to you.
• Automated & Real-Time Reporting: Once you set up the connection, you can schedule data refreshes. This means no more manually exporting CSV files and wrangling data in spreadsheets every month. Your reports will always reflect the latest information automatically.
• Easier to Share & Collaborate: Securely share insightful dashboards with stakeholders across your organization. Team leads, executives, and board members can access relevant views of the data without needing access to Sage Intacct itself.

Before You Begin: Essential Prerequisites

To ensure a smooth connection process, you'll need a few things in place first. Make sure you have the following:

• An active Power BI Pro or Premium subscription to share reports and set up scheduled refreshes.
• An active Sage Intacct account with appropriate permissions.
• A dedicated Web Services User role in Sage Intacct. A standard user account will not work for API connections. You'll need credentials for this specific user, including their user ID and password.
• A Web Services Sender ID and password. Your Intacct administrator can authorize a sender ID, which is a credential that allows external applications (like Power BI) to access your Intacct data.

If you don't have these Sage Intacct credentials, contact your company's Intacct administrator to have them created for you before proceeding.

Method 1: Using Power BI's Web Connector

Power BI can connect to data sources through web URLs. Although Sage Intacct doesn't offer a simple one-click connector, you can leverage its Web Services API. This method is the most direct but requires some technical comfort with constructing API requests. It's best suited for pulling specific, well-defined data tables.

Note: Sage Intacct's API can be complex. This method works but can become cumbersome if you need to pull and join many different tables.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions

1. Identify the Sage Intacct Data You Need

Before jumping into Power BI, know which "objects" (data tables) you want to pull. Are you looking for the General Ledger (GLDETAIL), Vendor information (VENDOR), or perhaps Accounts Receivable details (ARINVOICE)? Knowing this upfront makes the query process easier. The Sage Intacct Developer API documentation is a valuable resource for finding object names.

2. Create the Request in XML

Sage Intacct's API typically responds to XML-formatted requests. You’ll need to create a simple XML file that tells Intacct which exact data you want to retrieve. The structure of this query is what makes this method a bit tricky.

A basic request to get Vendor data might look like this:

<?xml version="1.0" encoding="UTF-8"?>
<request>
  <control>
    <senderid>Your_Sender_ID</senderid>
    <password>Your_Sender_Password</password>
    <controlid>request-control-id</controlid>
    <uniqueid>false</uniqueid>
    <dtdversion>3.0</dtdversion>
  </control>
  <operation>
    <authentication>
      <login>
        <userid>Your_Web_Services_UserID</userid>
        <companyid>Your_Company_ID</companyid>
        <password>Your_Web_Services_UserPassword</password>
      </login>
    </authentication>
    <content>
      <function controlid="function-control-id">
        <readByQuery>
          <object>VENDOR</object>
          <fields>*</fields>
          <query/>
          <pagesize>1000</pagesize>
        </readByQuery>
      </function>
    </content>
  </operation>
</request>

This is just an example. You'll need to create and store these XML queries for each data object you want to sync.

3. Connect in Power BI

1. Open Power BI Desktop and click Get Data from the Home tab.
2. Select Web from the list of connectors.
3. In the dialog box, select the Advanced option.
4. In the URL parts box, enter the Sage Intacct API endpoint URL: https://api.intacct.com/ia/xml/xmlgw.phtml.
5. In the "HTTP request header parameters" section, set the header to: Content-Type: x-intacct-xml-request.
6. In the 'HTTP request body' textbox, paste the XML query you created in the previous step.
7. Click OK. Power BI will send the request to Sage Intacct and show you a preview of the data in the Power Query Editor.

4. Transform and Load Your Data

The data will come back in a nested format. You'll need to use the Power Query Editor to expand the records and columns to create a usable, flat table. Once the data looks correct, click Close & Apply to load it into your Power BI model.

You would repeat this entire process for each data table you want from Intacct. This can be time-consuming, but gives you granular control over what data you import.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Using a Third-Party Connector

For most businesses, a dedicated third-party connector is the most practical and efficient solution. These services are designed to bridge the gap between Sage Intacct and Power BI, managing all the API complexity behind the scenes.

Using a pre-built connector offers several advantages:

• Simplicity: No need to write XML queries or manage API endpoints. The connection process is simplified to a few clicks.
• Reliability: These connectors are optimized to handle API limits, update data efficiently, and manage authentication for you.
• Performance: They often query data more efficiently than a manual web setup, leading to faster data refreshes.

Popular Connector Options

Several companies provide robust Power BI connectors for Sage Intacct. Some well-regarded options include:

• CData
• Progress DataDirect
• KPI Cloud

General Workflow for Connectors

While the exact steps vary by provider, the process is very similar:

1. Install the Connector/Driver: You'll typically download and run an installer on the computer where you use Power BI Desktop.
2. Find the Connector in Power BI: After installation, open Power BI, click Get Data, and search for the service name (e.g., "CData"). The dedicated connector should appear.
3. Enter Your Credentials: The connector will ask for your Sage Intacct login details, including your user ID, password, company ID, and sender ID. You only have to do this once.
4. Select Your Data: The connector will present you with a list of available Sage Intacct tables, much like a database. You can browse and select the tables you need.
5. Load and Report: The data will load into Power Query Editor for transformation, allowing you to start building your reports and dashboards immediately.

This method has an associated cost (usually a subscription fee for the connector service) but saves significant time and effort, making it the preferred choice for most teams.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 3: The Data Warehouse Approach

For organizations with large data volumes or the need to integrate many different data sources, a full data warehouse approach is the most scalable solution. This is the most complex method to set up but provides unparalleled power and flexibility for business intelligence.

What does this look like?

The data flow follows a structured path:

1. ETL Tool: An ETL (Extract, Transform, Load) tool like Fivetran, Stitch, or Matillion connects directly to Sage Intacct's API.
2. Cloud Data Warehouse: The ETL tool extracts the data, cleans it, and loads it into a central cloud data warehouse such as Snowflake, Google BigQuery, or Amazon Redshift.
3. Power BI Connection: Power BI then connects directly to the data warehouse — a connection it is highly optimized for.

When should you use this method?

• When you have massive amounts of financial data.
• When you need to perform complex data transformations and modeling before analysis.
• When you are blending Sage Intacct data with numerous other sources (CRMs, marketing platforms, operational databases, etc.).
• When query and report performance are your top priorities.

This approach turns your BI setup into a robust, high-performing analytics engine, creating a true "single source of truth" for all your company's data.

Final Thoughts

Connecting Sage Intacct to Power BI transforms your financial data from static records into dynamic, actionable insights. Whether you choose the direct web connection, a user-friendly third-party connector, or a scalable data warehouse, centralizing your data in Power BI will empower your organization to make smarter, more data-driven decisions.

For marketing, sales, and e-commerce teams, manually setting up and managing these connections in tools like Power BI can be a significant drag on time. At Graphed, we remove this friction entirely. Instead of configuring connectors and writing queries, you simply connect your data sources — like Shopify, Google Analytics, and Salesforce — and then ask for the dashboards and reports you need in plain English. We turn hours of technical setup into a 30-second conversation, so you can focus on analyzing performance, not just reporting on it.