Finance | Project Operations, Human Resources, ...

BPA (Business performance analytics)

(2) Share

Report

Posted on by Ramkishor reddy

266

Hello all ,

I installed BPA (Business performance analytics for d365 f&o ) and after installing I'm seeing all the tables. But i want to know how those tables are appearing here.

Thanks in advance!!

Regards,

Kishor.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Adis 6,064 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Could you explain the following please:

"But i want to know how those tables are appearing here"

I really dont understand what you mean.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Suggested answer

Saalim Ansari 666 on at

Like (1)

Report
Hello Kishor,

The tables you're seeing after installing Business Performance Analytics (BPA) in Dynamics 365 Finance and Operations (D365FO) are part of the standard BPA configuration. BPA leverages the Export to Data Lake feature to synchronize selected data entities and analytical models into Azure Data Lake Storage Gen2. These tables are automatically created and maintained by the system, reflecting transactional and master data exported from D365FO specifically for analytical use.

This synchronization ensures that the data is always up to date with the source system and is optimized for reporting and analysis using tools like Power BI and Azure Synapse Analytics.

For more detailed information, you can refer to the following resources:

Export to Data Lake in finance and operations apps

Business performance analytics FAQ

Hope this helps

Saalim

Was this reply helpful? Yes No
Ramkishor reddy 266 on at

Like (0)

Report

Hello @Saalim Ansari,

Thanks for your response.

I want to design a report with Project related tables. But I'm not seeing any project related Fact tables under Data node.

Question is Is it possible to add the project tables ? If yes how ?

Thanks in advance!!

Regards,

Kishor

Was this reply helpful? Yes No
Saalim Ansari 666 on at

Like (1)

Report

Hi Kishor,

Yes, it's possible to add project-related tables to BPA, but they aren’t included by default. You need to use Export to Data Lake in D365FO to export project entities like ProjTable or ProjInvoiceTrans, and then link them in Power BI or Microsoft Fabric to build custom reports.

Microsoft also covers this in their Extending BPA guide and Export to Data Lake.

You can also refer to Microsoft’s official BPA deck (DTV050EXT) Microsoft BPA Extensibility Deck —especially slides 13–23—for extensibility scenarios. Let me know if you need help getting started!

Hope this helps

Saalim

Was this reply helpful? Yes No