Connect Exact Online Power BI via OData

Why link Exact Online to Power BI?

Exact Online is for many Dutch companies the place where accounting, invoices, relations and sometimes HRM processes come together. This works fine for daily administration, but management reports often require more: current dashboards, turnover per period, margin development, outstanding items, accounts receivable, general ledger analysis and combinations with project or CRM data.

That's where Power BI comes into the picture. Finance teams want to not only view Exact Online data in Exact itself, but combine it with data from systems such as Simplicate, Bouw7, Robaws, ClickUp or Twinfield. Without a connection, this often ends in monthly exports. Someone downloads CSV files, adjusts column names, pastes tables together and hopes the definitions remain the same.

That is vulnerable. Reports become dependent on manual work, files become outdated and Power BI models are difficult to transfer to a colleague. An automatic Exact Online Power BI connection solves that problem by making the data structurally available.

The challenge with the Exact Online API

Exact Online has an API, but that API is built for developers. For a reliable Power BI dashboard, you need to arrange more than just calling an endpoint. Consider OAuth authentication, token refresh, division selection, pagination, rate limits, error handling, data types, relationships between tables and periodic synchronization.

You can build all this yourself in Power Query or a separate service, but then your report also becomes a maintenance project. If Exact Online hits a limit or a token expires, your refresh will fail. If a colleague takes over the report, he or she must also understand how the API logic works.

An OData feed is therefore often more practical for recurring reports. OData is a standard that Power BI and Excel natively support. Instead of putting API logic in your report, let a data layer retrieve the source data and provide Power BI with stable tables.

How DigiData makes Exact Online data available

DigiData works as an intermediate layer between Exact Online and your reports. You connect Exact Online to DigiData once via OAuth. DigiData then automatically retrieves the selected data and stores it in a structured manner in your DigiData environment.

You will then receive an OData feed that Power BI can load directly. In Power BI Desktop you choose Get data, select OData feed, paste the DigiData URL and choose the tables you need. The same data can also be exported to Excel or as a controlled CSV export.

The advantage is that Power BI does not have to wait directly for the Exact Online API. DigiData first processes the source data, monitors synchronization and delivers consistent tables to your reporting environment.

Conditions and prior check

You need a DigiData account, access to the correct Exact Online administration or division and Power BI Desktop. The Exact Online user you authorize with determines which administrations are available; therefore check in advance whether that user can open the intended divisions in Exact Online. Also note which totals and period you will compare the first synchronization with.

Step by step: Load Exact Online data into Power BI

1. Connect Exact Online with DigiData

Start in the DigiData dashboard and add Exact Online as an integration. You log in to Exact Online and authorize DigiData via OAuth. DigiData does not store an Exact Online password.

2. Select the administration or division

Many Exact Online environments work with multiple administrations or divisions. Choose which data you want to sync. For holding structures or multiple entities, this is important, because your reports often want to compare or consolidate divisions.

3. Wait for the first synchronization

DigiData retrieves the selected tables and prepares them as a structured dataset. Depending on the amount of data, the initial sync may take longer than subsequent updates.

4. Open Power BI and load the OData feed

In Power BI Desktop, choose Get Data and then OData feed. Paste the DigiData URL and select the tables you need. You can then establish relationships, build measures and publish your dashboard to the Power BI Service.

5. Set up scheduled refresh

You don't want to manually refresh management reports. Set up a scheduled refresh in Power BI Service so that reports automatically use current Exact Online data.

Resolve limitations and issues

If an administration is missing, first check the rights of the Exact Online user and then the division choice in DigiData. If a table is missing, compare the available entities with the Exact Online integration; not every field or component is available in every Exact Online setup.

If the feed works in Power BI Desktop but not after publication, check the source credentials and the authentication method set in Power BI Service. Microsoft also points out that an OData URL with query options may be treated differently than the service root in the connection test. In case of disruptions, start with the unchanged DigiData feed URL and add filters in Power Query.

Which Exact Online data is useful in Power BI?

For financial dashboards you usually start with relationships, invoices, general ledger accounts and transaction data. This allows you to analyze turnover, costs, outstanding items and debtors. For broader reporting, divisions, employees, salaries or other HRM-related tables are also valuable if they are available in your Exact Online environment.

A practical Power BI model does not use Exact Online as a separate export, but as a source layer. General ledger accounts form the financial structure. Relations and debtors help with customer analysis. Invoices and bookings provide the timeline. Divisions allow consolidation and comparison.

Once this foundation is in place, you can combine Exact Online with operational sources. Consider hours from Simplicate, project data from Bouw7, construction planning from Robaws or tasks from ClickUp. Then Power BI becomes more than a financial overview: it becomes a steering instrument for margin, planning and capacity.

Examples of Exact Online dashboards

A first dashboard is often a finance overview for directors or management. Here you show turnover per month, costs per general ledger category, margin development, cash flow indicators and outstanding items. Because the tables are synchronized on a recurring basis, no one has to prepare an export for every update.

A second dashboard focuses on accounts receivable and customer value. Combine relationships, invoices and payment terms to see which customers are growing, which customers make structural payments and where follow-up is needed. This is especially useful for SMEs that process many small invoices and want a quick overview without manually clicking through Exact Online.

A third dashboard is consolidation across multiple administrations or divisions. If you manage multiple entities, you want to be able to compare figures without maintaining separate reports for each administration. By using divisions as a dimension in Power BI, you can compare totals and detailed overviews.

The fourth dashboard is created when you combine Exact Online with operational data. Link invoices to hours, projects or planning and you will not only see what has been booked financially, but also why margin changes. This is precisely where a central data layer becomes valuable: finance, operations and management work with the same source data.

Create a reliable Exact Online data model

Start small with a data model that you can check. First load the tables needed for your main reporting question. General ledger accounts, periods and bookings are important for turnover and costs. For accounts receivable analysis you need relations, invoices and payment statuses. Divisions or administrations are essential for consolidation.

Whenever possible, use IDs instead of name fields to establish relationships. Names may change, but IDs remain more stable. Then create clear dimensions for period, relationship, general ledger account and administration. Measures such as turnover, costs, margin and outstanding amount belong in Power BI, not in separate Excel files next to the model.

In addition, always check totals against Exact Online itself. A good connection does not mean that you never have to check; it means that control becomes reproducible. If totals differ, you can take a specific look at filters, dates, VAT settings or which administrations have been included.

OData feed, CSV export or direct API?

For structural Power BI reports, OData is usually the best choice. Power BI can retrieve the tables repetitively, apply filters and save relationships in the data model. You don't have to download any files and the refresh can run automatically.

CSV export remains useful for individual checks or ad-hoc analyses. You determine exactly which period and columns you export and can share them with someone who does not use Power BI.

A direct Exact Online API connection provides maximum freedom, but also more maintenance. You have to solve authentication, error handling, limits and data model choices yourself. For many finance teams, that's not what they want to spend their time on.

DigiData therefore combines the advantages: automatically retrieve source data, provide tables in a stable manner via OData, and still keep CSV available for control or analysis outside Power BI.

Exact Analyze online data with ChatGPT, Claude and Gemini

In addition to Power BI, more and more teams are using AI tools to understand financial data sets faster. For example, you can use a controlled CSV export from DigiData to summarize deviations, formulate questions for the month-end closing or explore trends in accounts receivable.

Examples of useful questions are: which customers have noticeably changing payment behavior, which cost items differ from last month, or which turnover development should management see first? The value is not in a random export, but in a dataset that has first been neatly synchronized from Exact Online.

Always use your own data policy. DigiData helps by making data available in a structured and verifiable manner; your organization determines which data is allowed to go to AI tools.

Common mistakes at Exact Online in Power BI

The first mistake is building reports on manual exports. That seems fast, but after a few months different versions of the same truth emerge.

The second mistake is only loading invoices without reference tables. For good analyzes you also need relationships, general ledger accounts, divisions and periods. Otherwise you can add amounts, but not explain them properly.

The third mistake is putting API logic into Power Query without a management plan. If one person knows how the connection works, the dashboard becomes vulnerable when that person is absent.

A fourth mistake is thinking about definitions too late. Agree in advance what turnover, margin, outstanding items, cash flow and period filters mean. DigiData supplies the source data; Power BI turns that into your reporting logic.

When is an Exact Online Power BI connection worthwhile?

An automatic connection is especially valuable as soon as reports are recurring. Think of monthly closing, management reports, cash flow overviews, accounts receivable monitoring or dashboards for multiple administrations.

If you only do a loose check once a year, an export may be enough. But as soon as you manage figures on a weekly or monthly basis, a permanent connection saves time and prevents errors.

View the full Exact Online integration for the supported data and DigiData's approach. If you want to know what this costs, look at prices or contact contact directly for a demo.

Summary

Linking Exact Online to Power BI does not have to be an API project. With DigiData you connect Exact Online once, automatically synchronize the source data and load it into Power BI via an OData feed. This way you can build up-to-date dashboards without manual exports, separate scripts or vulnerable Power Query API logic.