Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Analytic between D365 ...
Finance forum
Unanswered

Analytic between D365 FO and Fabric ?

Posted on by 357
Hello everyone,
 
May I get few advices from experts here. If I want to learn about analytics in D365 FO with Microsoft Fabric, but I only have D365 FO installation from downloadable VHD (from LCS), what is the best way of doing it ? Is this possible ?
Understand that the D365 FO itself is consider as free and local, while resources for Fabric mostly Azure related, but is there any way to still able to use the data to show the integration ? then later I can use it inside Fabric. I even consider if I should buy Azure resources such the storage (Data Lake) or other component, obviously in the cheapest way possible, if I can make use my D365 FO, refresh data to build the integration more /real-time/ analytic alike.
 
Understand as well this is not really a D365 FO discussion, but to put this question in Fabric community is turn out to be more weird, or less popular.
 
Any advices are really appreciated.
 
Thanks.
 
  • Teevo Profile Picture
    Teevo 357 on at
    Analytic between D365 FO and Fabric ?
    Hi Andre,
     
    Unfortunately I tried and no is the answer.
    Thanks
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Analytic between D365 FO and Fabric ?
    Hi Teevo,
     
    Are you able to talk with your current employer about setting up an environment where you can practice exporting data to Data Lake via Synapse and create Power BI reports for your personal learning? There is no common playground in the community.
  • Teevo Profile Picture
    Teevo 357 on at
    Analytic between D365 FO and Fabric ?
    Hi Andre,
     
    Thanks for your reply. I wonder if there is a Developer / Community program to exercise this ?
    I'm techno-functional in D365 and wants to extend my self and somewhat change career to be data analytics but without "leaving" my experience or knowledge in D365. But I found companies using D365 FO in my area (Asia), it is very very rare to implement BI / analytics, so to have actual project in this is very difficult. But if applying for data engineer/data analyst, this is also very difficult because it needs experienced.
     
    Any advices ?
     
    Thanks in advance.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Analytic between D365 FO and Fabric ?
    Hi Teevo,
     
    For Data Lake, Synapse and Fabric, there are costs involved. You can use an Azure calculator for estimation of the costs. 
    To get data in a Data Lake, Microsoft provides now the Synapse Link which is available if the environment is connected with Power Platform. That is not possible with a local VHD. If you know how the data is stored, you can try to create own integration options to get data in the same structure. If you have it in a different format, you can still create reporting, but then having an environment connected to a Data Lake via the Synapse Link will need different reports. 

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…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,126 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans