68
Mainly for power bi scenarios. Retrieving large amount of data via odata is far too slow. Instead this data should be avalable via a read-only replica which can be accessed via sql directly.
This gap prevents us from providing a power bi based analysis portfolio to cloud customers, which is a show stopper for many deals.
This gap prevents us from providing a power bi based analysis portfolio to cloud customers, which is a show stopper for many deals.
STATUS DETAILS
Needs Votes
Business Central Team (administrator)
Thank you for your feedback. Currently this is not in our roadmap; however, we are tracking it and if we get more feedback and votes, we may consider it in the future.
There is a way to achieve read scale-out through Odata though: Use API queries and set the DataAccessIntent property to Readonly. See more in the performance tuning guide here: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/performance/performance-developer#performance-patterns-do-this
Sincerely,
Kennie Nybo Pontoppidan
PM, Microsoft