Finance | Project Operations, Human Resources, ...

Recommended way to connect Power BI with F&O? Dataverse virtual entities or synapse link?

(1) Share

Report

Posted on by Migi

304

If I'd use CDS legacy connector and publish F&O entities to dataverse, would it be a heavy solution from performance point of view?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Migi,

Depending on what exact entities you will use, it can have a performance impact due to a specific load on the application. Microsoft provided options to export data to have a data source for reporting that is not impacting the performance of the application. Querying transactional data from BYOD or Data Lake/.Synapse link is preferred above virtual entities that is reading the data from the live application.

Was this reply helpful? Yes No
AR-01121610-0 4,967 Moderator on at

Like (0)

Report

Hy,

basically at a first I would ask for the requirement of the reporting. Is it a operational report, does it need aggregations or is it analytical reporting, what is the expected volume of data.

Then we can give a recommendation what the best way is to provide the needed data to the PowerBI.

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (0)

Report

Hi,

Finance and Operations connector has some performance limitations based on its current design, For each request sent to the FnO connector, a call is made to FnO to retrieve the metadata. This call is slow and will take around 10 seconds.
If the FO Connector is slower than expect and, you can alternatively use Dataverse connector and FO Virtual entities instead.

Application Connector - Finance & Operations | Dynamics 365 | Microsoft Learn
Fin & Ops Apps (Dynamics 365) - Connectors | Microsoft Learn

Best Regards.

Judy

Was this reply helpful? Yes No
Suggested answer

CU10052004-0 2 on at

Like (0)

Report

Hi Migi,

Not sure what solution you have went with, you may want to consider use Synapse Link.

I followed this page (https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/enable-virtual-entities) to enable the entities I was interested in. You may need to change the Allow Row Version Change tracking property in Visual Studio, if the entity you want isn't available.

I waited for a couple hours and then I followed this page:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-data-lake
You might be able to see your table show up sooner, I didn't time it exactly.

Click Manage tables, wait for it to load, then search for ‘mserp’, this should show the entities that you had set to be visible previously.

Select the entities that you are interested in and click Save.

After it finishes syncing and shows an Active Sync status, approximately 20-30 minutes, you should be able to use SQL Management Studio to connect to your synapse link database, see the mserp_ entity table and use it in a query.

From what I've seen so far, it performs well.

Hope this helps!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Recommended way to connect Power BI with F&O? Dataverse virtual entities or synapse link?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Recommended way to connect Power BI with F&O? Dataverse virtual entities or synapse link?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates