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?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

AR-01121610-0 4,967 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Anthony Blake 2,975 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

BYOD on D365 FO

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

BYOD on D365 FO

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates