# Create Custom reports on Sage Intacct and use them on Power BI via Connect Cloud

**URL:** <https://community.cdata.com/t/create-custom-reports-on-sage-intacct-and-use-them-on-power-bi-via-connect-cloud/916>\
**Category:** How-to with CData\
**Tags:** article, connect-cloud\
**Created:** [October 16, 2024, 1:45pm UTC](https://community.cdata.com/t/create-custom-reports-on-sage-intacct-and-use-them-on-power-bi-via-connect-cloud/916 "2024-10-16T13:45:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dibyendu](https://avatars.discourse-cdn.com/v4/letter/d/838e76/32.png) [@Dibyendu](https://community.cdata.com/u/Dibyendu)\
**Post date:** [October 16, 2024, 1:45pm UTC](https://community.cdata.com/t/create-custom-reports-on-sage-intacct-and-use-them-on-power-bi-via-connect-cloud/916/1 "2024-10-16T13:45:20Z")

</div>

[Sage Intacct](https://www.sage.com/en-us/products/login/) is a cloud-based financial management platform used for automating accounting processes, managing core financials, and providing real-time financial reporting and insights for businesses.

Custom reports in Sage Intacct allow users to customize financial and operational reports based on their business needs. Organizations can gain relevant insights into their financial performance by selecting custom filters, dimensions, and data fields.

[CData Connect Cloud](https://www.cdata.com/cloud/) supports custom reports in Sage Intacct (and other data sources), enabling you to configure predefined reports that can be queried as views within your connections. Each report has specific input requirements, which you provide when setting up the report in your Connect Cloud account.

In this article, we’ll show how to create a custom report in Sage Intacct and configure it in Connect Cloud. Finally, we’ll explore linking these custom reports to Power BI using CData Connect Cloud.

**Creating a custom report in Sage Intacct**

Follow these simple steps to create a custom report on the Sage Intacct platform:

1. Log into your **Sage Intacct** account.

2. On the top left section of the application, click on the **Applications** dropdown list.

3. Select Reports from the left panel and click on **Custom Reports** under the  **Advanced** section.

 ![AD_4nXe7lwHTCO7EXndhyiK-kf2CDpEPtlXVGZV5CGp-gDYXTHeCOcLwDEkt0p_0S0AfNjYGUYN20GZFjes42JbQROP5ioMpBQEWO638rACteyylXAVC56LeGdAYwsvyyceEP0uUhWnTlNWVfqadnXiNS2dpPzDI?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/1X/1331d17c4317d6f75aa281abaeafe53fce752dce.png)

1. Click on **Add**. The **Custom report wizard** screen will open.

 ![AD_4nXcbsLJuV-K-uMiFTdN6tnRDRxxbZmktg2MZSS8kI_60F6u0v0Op5DZOmOcEVnfJwHDmkhMqyotpAsQ1FjDE9glr7a9KYYeJ_8EgCXWLvrC7DxqpMwmWv28FDAmuhg7T2qT9m0LlViwbSPJyLypjyFbpFItG?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/1X/1d505e2a2c757d47e9fcc77d871981fd42c53b6e.png)

1. Fill in the **Primary data source** , **Report audience** , and **Report type** dropdown lists.

 ![AD_4nXehdYr5vpYXP4zgBLkbwJXWWUlj0V2IMH8-JV0sOg1uVdSA2rvdRDrX3I47u04PN3dKsDV34V9mU3uAF7DULOMXwi8ZP5zys3BUUnUF1rpKeeNOBX0uxE2fX5B4vOosbQGlHAh2WX8kfXQbuJfus0o81do?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/2X/9/97ba58fffa48f4ebbf09a58d6572e0722d69c546.png)

1. Click on **Next** each time to follow the steps from 1 to 10 and add the necessary details to create the custom report.

 ![AD_4nXcUSTHHVIYWXvls7Jrx4a8IxVw-Q00Vy9f7tI0yesODOWSM9nZmN8T8W-V5EIbD7Xw7MigxB36BzMeKiVl_smscYfRFeJV5_HyG_zP7UOrqR2yrdycnIE_yjJiz-Hq9Ya7Q-Yc4QoOOhig5vD4ERFfuhLym?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/2X/3/3702e588d8aed4655b14c86433ddbf69d80f0869.png)

1. In the last step (step 10), provide a name to the report and click on **Save & new**.

 ![AD_4nXd8hSi9gwkslSg7axS5Fgl7m-p5w5njDF3b1Iw6xZFgjkD3VVUktuLGZaasDyo3uc6z5OXJCy1jOvvnP8M19brIPF3_VCRmGbwOyF-GXsWFpWvSUftRpqcK5Kox7oT0dHJ7ILJnaf2LEC8Gz4KnCLpyacC-?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/1X/f9127899b25627b47a45afe47236917a8de7eaf6.png)

1. The new custom report is now created and added to the list of Custom reports.

 ![AD_4nXci17F1PjXzqNxpAa4mOFek3pwnYx9ZTqgYs6hXRTxImjwbN-8Ppqn4UfaHkpaE6TvoWaW6SwTS5ZcLJ4F5uqIBxijeak4aEiYuicvlKXjE9FwKmceGnuYUXCYsuwuxVYXqX2PIPnrA4h9XRAQmTRGIdAI?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/1X/65f00cd4f0a98a406f081ee141a2fb59dc52552d.png)

**Adding a custom report to the Sage Intacct connection in CData Connect Cloud**

To begin, add and configure a new Sage Intacct connection to your Sage Intacct account in CData Connect Cloud. Follow the steps in the Connect Cloud [Sage Intacct setup guide](https://cloud.cdata.com/docs/SageIntacct.html#setup-guide) to establish the connection.

Now, add the custom report in the Sage Intacct connection following the given process:

1. Open the Sage Intacct connection in Connect Cloud.

 ![AD_4nXcXKjX0DI2rL1jifdQb_wS43Tjr3znMZ5m_RfQ53DreYkQV5u3aqoB1HTEfnd0dd95jE1GWxv2Hb5KFL5l8je9_rT4OZZEtxTLMy3C21qdKHOu5YuWDKznO88ZZAJdSZ8JyoITD9eb2RlQn8-eHvlMDwqWx?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/1X/1977ed85b6b0d8d74c5b4e49d63457ca4b6908b3.png)

1. Since Connect Cloud supports custom reports in Sage Intacct, a [Custom Reports](https://cloud.cdata.com/docs/Connections.html#configuring-custom-reports) tab will appear on the connection settings page. Clicking this tab opens the custom reports interface, as shown below:

 ![AD_4nXf_yU5LiDjTYeCRPJjlR24PKnuAiNROXtKHcIljDM9E-NPcI9SeQkh3rifOWExpTSBCuUy4A2o-h0Y6gAZBJOYWjP1sg5iMy0KHQcDMEZf4ZlwPkjjNs13mOOEAy9WO_LGRy-JHM8lAI7ZEzCcqq6BGNr-a?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/1X/8f1352f127313f040b7500bff11e42181edadfea.png)

1. Click on **Add**. The **Add Custom Report** page opens up. Add the custom report name (created in the last section) to the  **Report Name** and click **Save**.

 ![AD_4nXehebRDoq_76Q_HLR_jqO2zQc6H25BS6Rs6U9qRJ2QQj31qCuYQD4bYKvULNn3srlnQfMkShrEnnbNUTK6zhzT20BbFQ2D5k_VubWDjaeHqfkWJaamdIZnJVPV_uIzO6hr6i1TFXZjSVJl5kss1uRzPwgxA?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/2X/c/c4f980943e45eb164ccfa3b43cbec6dd39680e56.png)

1. The report gets added to the list of all the custom reports in the Sage Intacct connection.

 ![AD_4nXf4YqPMKxO3BSdSORWo9oPcY7EjrmQIe6RLqUJZtgWUZQF9wRxqFO3rx_SoNCnKYx39H1Cxwlk5XffljDYPuggBLn4qZ8Uwx8HVAb9tAUb1InL7YqbfVWU-WtmonRsbizV9nTvKp3ka_QO0W8ZhcXn1Rtfe?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/2X/d/d183e021a57f675278e5c270d9b5f93c741e96be.png)

1. Click on **Data Explorer** from the panel on the left. Click on the Sage Intacct connection and expand the same.

2. Now, search for the custom report you added. When it appears in the list of tables in the Sage Intacct connection, click the three dots on the right and select **Query**. (Alternatively, you can create your query using the [Query Builder](https://cloud.cdata.com/docs/QueryBuilder.html) or [AI Generator](https://cloud.cdata.com/docs/AIGenerator.html) feature.)

 ![AD_4nXdwxoEpIiR-EVSCLKajXo1BVDQ8ccHbOnPD9LMqdGXPOnv7Z6jfgnb_f3nGSLt25ZGs2iRKAJuo5LNbBMK_nJbPxC5NfwWD8z_CrxXhev1SkMmleFOUEaPOOK4KeYeCY5uCiu-7eEhtYkJr7eUSzeuZW-LD?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/2X/f/f30a16492a7bcf1b4b4dc6517931438b4f45983b.png)

1. After writing the query, click **Execute**. The data from the Sage Intacct custom report will load on the screen.

 ![AD_4nXdTeTi2tVnfyLF1TgLkB9jmhkZeU4wkATFjSae5kVtkHaWScJvsC1Yc7TC2_NkLrWjfD8R5jSoEOzbhMYZxivtElH8mt986MBZqRJ5nrniMvMKlDGQQKseoQ5RJJzJ5XJaSdwjV01YJ7OWIyQB1boCDHvF8?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/2X/1/17e8688557fc8584db25121ade9d7743b267539c.png)

**Connecting to the custom report with Power BI via Connect Cloud**

In this section, we’ll show how to connect and access Sage Intacct custom report data in Power BI using Connect Cloud. Here are the quick steps:

1. Connect to CData Connect Cloud in Power BI. Follow the steps demonstrated in the [KB article](https://www.cdata.com/kb/tech/intacct-cloud-powerbi.rst) to make the connection.

2. Next, open the Sage Intacct connection in Power BI and search for the custom report. The data will preview on the **Navigator** window.

 ![AD_4nXelCk9xan2s9aCqXHAcMEZsxvPub3Oe0LgfdJ1x30iog9ljWlVPLZbn1PUMhTnL9wHCDgSPZbrUJmCq28EJTAaFrToFl0KknzXVh_9lAJZ7XtvsVelg947Ax9toMghyIMyO3GOjl69gQ1G6eQ7AAEslQTIE?key=eDL4Q--08ewGlxIIYXo4Mw](https://us1.discourse-cdn.com/cdata/original/1X/2ea3f678f381a9b04678fd3abf42c51f2c4889e6.png)

1. Click on **Load**. You can now create visualizations with your Sage Intacct custom report data.

**Try CData Connect Cloud today**

To get governed access to hundreds of SaaS, Big Data, and NoSQL sources for live data consumption and analysis with your favorite tools, sign up for a [free 30-day trial of CData Connect Cloud](https://cloud.cdata.com/auth/sign-up-initial)!

# &nbsp;