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, ... / D365F&O database acces...
Finance | Project Operations, Human Resources, ...
Unanswered

D365F&O database access in Power BI,

(0) ShareShare
ReportReport
Posted on by CU22111441-0 64
Hello, 
 
Can I get direct db access of D365F&O in Power BI.
 
Kindly give me some reference to access of D365FO in Power BI.
 
thanks!
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,258 User Group Leader on at
    D365F&O database access in Power BI,
    Hi,
     
    No, you cannot directly (using direct connection to database)
     
    You have a few indirect options.
     
    1) use BYOD, which pushes the Dynamics data entities' data to an AZURE SQL (Azure SQL purchased by your organization) 
     
    2) use Azure Synapse link
     
    3) use Fabric Link 
     
    4) Microsoft also has something called, Power BI embedded reports and analytics workspaces in Dynamics (which are based on entity store Measures) but this is becoming less relevant, as Microsoft continues to invest more in Fabric and tools like BPA. https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/power-bi-embedded-integration
     
     
     

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 763 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
CU05031448-0 Profile Picture

CU05031448-0 544

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans