Hi,
I want to develop Power BI reports and show data live from D365FO. Please suggest what should be best options
Will appreciate any kind of pointers.
Thanks
Entity store or BYODB is never real time. For true real time you would need to use OData, but then you should keep your queries small because OData is slow.
Could you explain what you expect with "real time" and what's the underlying business requirement? Normally near-real-time (with perhaps a couple of minutes delay) fits most reporting requirements and is much less stress for your D365 system. Perhaps you can mix these approaches, using mostly near-real-time and then querying only the critical real-time information that your business really really needs.
I still have not found the correct solution.
The requirement is to show real time data. Seems like with entity store and byod, i wont get real time data even if i use Direct mode in creating Power BI report.
Please suggest me some other alternatives which are workable or may be give me more insight to me on how can i use make data available real time using entity store or byod.
Hi Jeff,
All experts have shared all relevant information so if you seek more information let us know.
Please find the below summarized suggestions to meet your requirement. Kindly review the suggestions and let me know if still need any questions, Thanks.
Entity store is an operational data store that is built specifically for Power BI integration. To create high-volume, near-real-time Power BI reports that use Entity store, a business analyst or a developer can use Power BI desktop.
For more reference: docs.microsoft.com/.../power-bi-integration
Alternatively, If you want real time refresh, you can use Entity store available in Azure data lake.
For more info: docs.microsoft.com/.../entity-store-data-lake
Hope this clarifies your query. I'm marking this thread as answered. Please let me know if you have any questions or any additional inputs needed, Thanks.
Yeah Embedded Power BI is an option and if user is not in D365FO, Admin can share reports with others using PowerBI.com.
also if the need is for users already having access to D365FO then embedded POwerBi could be the preferred choice
if users are not in D365FO then using BYOD would be ideal
Good morning Jeff,
There have been a number of feedbacks and links provided.
Can you let us know if you need any other information from the community or whether we can verify the answers and thereby complete this thread?
Many thanks and best regards,
Ludwig
Jeff,
If you are looking for streaming dashboard capabilities on factory floor or work metrics, you can use push or streaming data set or push.
docs.microsoft.com/.../service-real-time-streaming
For pushing the data to powerbi you have to connecto to powerbi rest api from the D365 application. This is the hard part and will need you to involve developers.
If you are ok with near realtime then publish entity store to data lake storage.
docs.microsoft.com/.../entity-store-data-lake
With entity store you have to periodically refresh the powerbi dashboard instead of a streaming data.
You have 2 options:
Entity Store that is near real time https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/power-bi-integration#creating-high-volume-near-real-time-operational-power-bi-reports-by-using-entity-store
BYOD https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/export-entities-to-your-own-database that can be incrementally updated, but it is not real time as well.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 789 User Group Leader
André Arnaud de Cal... 607 Super User 2025 Season 2
Martin Dráb 497 Most Valuable Professional
