Limitations of BYOD in D365 F&O

Bring your own Database (BYOD) is a feature in D365 F&O that enables the customers to store business data in their own databases. The data is exported to BYOD database using data entities. You can create global reports from all legal entities using BYOD database. In D365 F&O, BYOD is mainly used for Power BI reporting. It is great feature, however there are some limitations that customers should be aware of before implementing it

• Data Synchronization

BYOD requires additional configuration and management to ensure that data is synchronized correctly between the D365FO database and the BYOD database. Real time data sync is not supported and BYOD depends on batch jobs to export data from D365 F&O.

• Composite Entities not Supported

You can not export composite entities to BYOD. Each entity in the composite entity must be exported.

• Incremental Push Limitation

Only Data Entities that have Unique keys are supported for incremental push.

• Security

Customers are responsible for securing the BYOD Database, so additional efforts are required.

• Scalability

Scalability can become issue after a certain point, as BYOD database’s scalability depends on the capacity of Azure SQL Database. In this regards, Azure Data Lake is highly scalable and can store large volumes of data.