Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Recommended way to con...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by Migi 266
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? 
  • Suggested answer
    CU10052004-0 Profile Picture
    CU10052004-0 2 on at
    Recommended way to connect Power BI with F&O? Dataverse virtual entities or synapse link?
    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!
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Recommended way to connect Power BI with F&O? Dataverse virtual entities or synapse link?
    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.
    Best Regards.
    Judy
  • Andreas Raithel Profile Picture
    Andreas Raithel 4,881 Super User 2025 Season 1 on at
    Recommended way to connect Power BI with F&O? Dataverse virtual entities or synapse link?
    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.
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,468 Super User 2025 Season 1 on at
    Recommended way to connect Power BI with F&O? Dataverse virtual entities or synapse link?
    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans