Microsoft Dynamics 365 | Integration, Dataverse...

How to extend business performance analytics dataset, as well as the platform to utilise?

(3) Share

Report

Posted on by HA-03070711-0

Actually, I'm working on business performance analytics in Dynamics 365 Finance to extend dataset. This dataset consists of fact and Dim tables.

Please see below in snapshot:

I'm facing a problem how to add new custom fields withing existing facts, dimensions tables, for that I looked up this below article to extend an existing fact or dim table, but there is no reference of the Plateforme mention on which this activity will be perform and also unable to find any proper material on the internet for these practices mentioned in the MS documentation.

https://learn.microsoft.com/en-us/dynamics365/finance/business-performance-analytics/extending-bpa#extend-existing-fact-tables-by-adding-measures

Kindly suggest me solution to achieve this goal.

Categories:

Dynamics 365 general

Power Platform integration

I have the same question (0)

All responses (4)

Answers (0)

Sort by

CU03071002-0 4 on at

Like (1)

Report
Copy link

Link copied!

You can extend the BPA dataset in Dynamics 365 Finance by using Microsoft Fabric. First, enable the “Extend to Fabric” feature to make the BPA tables available in Fabric. Then, you can add your custom fields directly in Fabric, either by modifying existing fact or dimension tables or creating new ones. After that, update your ETL process to load the data into these fields. Once done, refresh BPA so the changes show up in reports.

Was this reply helpful? Yes No
HA-03070711-0 19 on at

Like (1)

Report
Copy link

Link copied!

@CU03071002-0

Thank you for your support—it's truly appreciated!

How I enable the “Extend to Fabric” feature to make the BPA tables available in Fabric. And is any prerequisite for it.

Can I perform these steps to enable “Extend to Fabric” feature:

Connect Business performance analytics data to Microsoft Fabric (preview) - Finance | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
HA-03070711-0 19 on at

Like (0)

Report
Copy link

Link copied!

Here is a link, in which they guide step by step to extend BPA dataset:

https://www.yammer.com/dynamicsaxfeedbackprograms/#/groups/73748324352/files

BPA Extensibility...

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi there,

Extending existing fact and dimension tables in Business Performance Analytics (BPA) within Dynamics 365 Finance can be a bit tricky, especially since the documentation doesn't always specify the platform or tools clearly.

Here are a few steps to help guide you:

Platform Context:

These extensions are typically performed within Data Management Framework (DMF) or Power BI integration layers, depending on how BPA is configured in your environment.

Extending Fact Tables:

To add custom fields (measures) to a fact table:

Use Visual Studio with the Finance and Operations development environment.

Extend the relevant table via a table extension and add your custom fields.

Then, update the Aggregate Measurement to include the new fields.

Extending Dimension Tables:

Similar to fact tables, use table extensions to add fields.

Ensure the dimension is properly linked in the Data Entity and Aggregate Measurement.

Deploy and Refresh:

After making changes, deploy the model and refresh the Entity Store so that Power BI or BPA can pick up the new fields.

Documentation Reference:

The article you mentioned is a good starting point, but for hands-on steps, refer to:

Extending Aggregate Measurements

Entity Store and Power BI Integration

Let me know if you need help with the development steps or setting up the environment!

Please verify if this response was helpful.

Best regards!

Was this reply helpful? Yes No