loader image


Share on facebook
Share on twitter
Share on linkedin

How to add planning and budgeting with Business Central NAV in Power BI

Planning & Budgeting For Business Central and NAV

Power BI offers unparalleled features for analysis and visualization: in this post we explain how you can add comprehensive planning and budgeting with all editions of Business Central and NAV.

How to:

1.Add your required tables from Business Central / NAV  to Power BI. This can be done either via existing Power BI reports that come with Business Central, the Power BI Business Central Connector or with synchronized tables in MS / Azure SQL  Server:

Dynamics Tables
Dynamics Tables 

2. Install the latest version of Acterys Power Sync. This Windows application enables you to create a planning model with any table from Business Central / NAV:

Acterys Power BI Sync Architecture

3. Start the application. Now you will see the following screen:

Acterys Power BI Sync and Update
Acterys Power BI Sync and Update

4. Click on the configuration area at the top and configure your Power BI model (Power BI Desktop or Power BI Dataset / Dataflow):

Power BI Sync Configuration
Power BI Sync Configuration

5. Once you have configured the you can choose model tables that you want to use either in Power BI Desktop or as a published Power BI Dataset /Dataflows. Here you can also set automatic refresh interval to update changes in Business Central / NAV to SQL Server / Acterys:

Acterys Power BI Sync-Scheduled-Tasks
Acterys Power BI Sync – Scheduled Tasks

6. Add the new Acterys tables to your existing or a new Power BI report.

7. Now you can use all planning features available in the Acterys Power BI visuals: Acterys Power Sync

Power BI Sync Planning for any Power BI model
Power BI Sync Planning for any Power BI model
Acterys Table Edit visual new features
Acterys Table Edit
Acterys Gantt Power BI Visual
Acterys Gantt Power BI Visual

Recent Posts

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.

Power BI offers unparalleled features for analysis and visualization: in this post we explain the quickest way to connect Oracle Netsuite in Power BI Deskop and how you can add comprehensive planning and budgeting.After your account has been setup, click on the “Integration” menu and go to the “Oracle Netsuite” section:

The default visuals in Power BI are not perfectly suited for financial reporting. There are ways to realize more advanced financial reporting requirements using DAX as Managility describes in Income Statement using DAX These, though typically require intermediate knowledge of DAX that many financial professional don’t necessarily have.

The Acterys Modeller is cloud based service (with on-premise installation option) that allows enables business users to automatically create optimal analysis models (star schema data warehouse) from a variety to ERP. accounting and SaaS systems. The created models are write and planning enabled and can be edited and extended as needed by business users e.g. for adding new products/attributes, account mappings, new scenarios etc.