Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Recommended way to con...
Finance forum
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by Migi 138
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? 
Categories:
BI and Analytics
  • 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
  • andreasraithel Profile Picture
    andreasraithel 4,643 Super User 2024 Season 2 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... 290,339 Super User 2024 Season 2 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. 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans