Finance | Project Operations, Human Resources, ...

BYOD on D365 FO

(1) Share

Report

Posted on by PP-29040829-0

Dear Community Group,

If I want to use BYOD, first I must create an Azure SQL database store. But I don't know if I can create a new BYOD on the current UAT test or test data. Second, if I want to extract data from Dynamics 365 FO for the Power BI process, do we have another solution, or must I use BYOD?

All responses (2)

Answers (0)

Suggested answer

Anthony Blake 2,359 Super User 2025 Season 1 on at

Like (0)

Report

BYOD on D365 FO

Hi,

The modern alternative for data warehousing is setting up Azure Synapse Link:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-select-fno-data
Suggested answer

Andreas Raithel 4,932 Super User 2025 Season 1 on at

Like (1)

Report

BYOD on D365 FO

Hy,

to setup the Azure SQL for BYOD export you need support of your Azure or DBA Admin if you are not aware of the process how to do this.

Starting point for the F&O tasks is here Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | Microsoft Learn

But as BYOD is expensive and not any longer state of the art there ar are othjer options

For the PowerBI reporting I would firstly have a clear vision of what data have to be analyzed with the Power BI.

If this is clear you can evaluate the out of the box F&O tabular data entity store which is a Datawareouse covering a lot of the F&O modules. These reports can be consumed mostly within F&O as we call it embedded Power BI reporting. These reports can also be modified and enhanced by development.

Take a look here for standard Power BI embedded reporting:

Power BI content home page - Finance & Operations | Dynamics 365 | Microsoft Learn

For further data processing you can start to work with most modern state of the art techique to use Microsoft Fabric for all post transactional data processing. This requieres F&O connected Dataverse environemnt means you will need also PPAC access to configure.

Link all Dynamics 365 data to Microsoft Fabric | Microsoft Learn

Hope this helps

Herzliche Grüße / kind regards,

Andreas Raithel

D365FO Solution Architect