Microsoft Dynamics 365 | Integration, Dataverse...

Business Performance Analytics error

(1) Share

Report

Posted on by aqeel2020uae

193

Dear Experts.

We are trying to install Business Performance analytics tool after all validation given by Microsoft but getting error in mid of installation.

refereeing to below link

What is Business performance analytics? - Finance | Dynamics 365 | Microsoft Learn

Thanks in Advance

Categories:

Power Platform integration

I have the same question (0)

All responses (5)

Answers (0)

Sohaib Cheema 47,704 User Group Leader on at

Like (0)

Report
Business Performance Analytics error

Hi @aqeel2020uae

I can see your error message tells us two things.

1) Unable to complete updates to the Track changes option for table:

First error is mentioned on the BPA Faq(s) section:

However, since retrying the installation (which I hope you have done) hasn't helped, let's move on to the next error message visible in your screenshot

2) Exception details: InnerJoin not supported for JoinDataSourceRelation(s). Use JoinRelationName(s) instead for the embedded datasource

This second error is mentioned on the setup of Enable row version change tracking for data entities

So, three questions:

Have you enabled Enable row version change tracking in the Dynamics 365 Finance & Operations system?

Is your Data entity customized?

What version of Dynamics you are on?

Was this reply helpful? Yes No
aqeel2020uae 193 on at

Like (0)

Report

Business Performance Analytics error

Dear Mr. Umesh.

We are following the same steps and things but while last step on BPA installation we are getting error.

What is Business performance analytics? - Finance | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,308 User Group Leader on at

Like (0)

Report

Business Performance Analytics error

Check prerequisites:
The environment must be Tier 2 or higher.
D365 version must be at least 10.0.38 (or higher for latest features).
Required privileges for both Power Platform and D365 FO must be assigned (System Administrator/System Customizer roles).
All relevant license configuration keys must be enabled (General journal, Bank, Procurement, etc.). Maintenance mode (via LCS) is required for license config changes.
The Finance and Operations virtual entity must be installed and enabled before installing the Business Performance Analytics solution.

Was this reply helpful? Yes No
aqeel2020uae 193 on at

Like (0)

Report

Business Performance Analytics error

Dear Mr. Sohaib.

Thanks for your time. No there is no customization in Test Env.

First I installed Virtual Company from power Platform. While i am install Business Performance analytics getting error.

We can re build data entity in case if your consider its changed or customize.

Thanks

Aqeel.

Was this reply helpful? Yes No
Sohaib Cheema 47,704 User Group Leader on at

Like (0)

Report

Business Performance Analytics error

Hi @aqeel2020uae

1) Do you have any GL data entities customized that are used in the BPA as virtual entities?

2) are you trying the installation on a test system or Prod system

Was this reply helpful? Yes No