web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Microsoft Dynamics 365...
Finance | Project Operations, Human Resources, ...
Suggested answer

Microsoft Dynamics 365 - Finance & Operations AND Fabric AND PowerBI

(1) ShareShare
ReportReport
Posted on by Community member
We are on the verge of completing our implementation of FO and simultaneously planning to build new PowerBI models for our new solution. Then Fabric emerges on the horizon. Does anyone know how FO's SQL database fits into Fabric?
I have the same question (0)
  • Community member Profile Picture
    Community member 2 on at
    Microsoft Dynamics 365 - Finance & Operations AND Fabric AND PowerBI

    How FO's SQL database can be integrated with Fabric:

    • FO's SQL database can be used as a data warehouse or a data lake in Fabric.
    • Using Fabric as a data warehouse makes it easy to integrate with Power BI, but it requires changes to FO's database.
    • Using Fabric as a data lake makes it possible to keep FO's database intact, but it is more complex to integrate with Power BI.
    • Using a hybrid solution combines the benefits of both data warehouse and data lake approaches.

    The best way to integrate FO's SQL database with Fabric will depend on your specific needs and requirements.

    I hope this helps!

    https://www.marykayintouch.website/

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,449 Super User 2025 Season 2 on at
    Microsoft Dynamics 365 - Finance & Operations AND Fabric AND PowerBI
    If you are using a cloud instance of Dynamics 365 F&O, you can't directly connect the SQL database as it is part of the cloud service. You would need to export the data to Azure Data Lake which can be used as a data source in Power BI. See also the documentation: Export to Azure Data Lake overview - Finance & Operations | Dynamics 365 | Microsoft Learn
  • Suggested answer
    RudyZhang Profile Picture
    RudyZhang Microsoft Employee on at
    Microsoft Dynamics 365 - Finance & Operations AND Fabric AND PowerBI
    Hi,
     
    Regarding your question about FO's SQL database fits into Fabric
     
    You can import your SQL data into Fabric using shortcuts in CETaS and OneLake. then, use this data in Power BI
     
    The following video will give you some guidance.
    https://www.youtube.com/watch?v=DB8zujLjzVo
     
     
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
     
    Best Regards,
    Rudy Zhang

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 694 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 635 Super User 2025 Season 2

#3
CU05031448-0 Profile Picture

CU05031448-0 576

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans