Hello Experts,
We are currently exploring integration between Dynamics 365 Business Central and Power BI to enable real-time analytics and financial reporting.
I’d like to understand from those who have implemented this:
• What integration approach did you use (standard connector, APIs, or data warehouse)?
• Did you face performance or data refresh challenges?
• How did you manage real-time vs scheduled refresh scenarios?
• Any recommendations for data modeling or security setup?
Appreciate any insights, lessons learned, or best practices.