web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / On-premise BYOD
Finance | Project Operations, Human Resources, ...
Suggested Answer

On-premise BYOD

(4) ShareShare
ReportReport
Posted on by Mandeep.S 283
Hello Community,
 
I have an on-premise deployment of FnO and we want to use PowerBI for dashboards etc using the BYOD concept.
 
But, the Microsoft documentation talks about connecting the on-premise database to an Azure SQL db for creating and syncing a BYOD database. Is there a way to create an on-premise BYOD database and connect to it with PowerBI ? 
 
Appreciate help/suggestions on this.
 
 
Thanks
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,574 Super User 2026 Season 1 on at
    Hi Mandeep,
     
    Yes, there is a way to create a local BYOD database and this database will be hosted on a local SQL Server environment. Ensure that the environment is scaled up if the data count is more than 1 million transactions. 

    Connection string to connect to the local BYOD Database:
    Data Source=<SQLServerName>;Initial Catalog="BYOD";Integrated Security=False;User ID=axdbadmin;Password=<axdbadminpassword> 
     
    PowerBI Connection:
    In this case, you will have to setup a PowerBI gateway and point your connection to the byod database. The gateway has to be setup for the same to work.
     
    A few questions:
    1. Will this be an entity store push
    2. Or Will this be a proper BYOD data entities publishing that publishes the corresponding staging tables in the above mentioned BYOD database?
     
    References:
  • Suggested answer
    Aymen CHELBI Profile Picture
    Aymen CHELBI 592 Super User 2026 Season 1 on at
    Hello,
     
    I suggest you check the connection. When you click on "Validate," you should see the following message:
    "Tests completed successfully. Current BYOD tier is 'ElasticPool'."
     
     
     
     
    Best regards,

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 738

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 453 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 286 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans