Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / On-premise BYOD
Finance | Project Operations, Human Resources, ...
Suggested answer

On-premise BYOD

(2) ShareShare
ReportReport
Posted on by Mandeep.S 244
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
  • Suggested answer
    Aymen CHELBI Profile Picture
    Aymen CHELBI 183 on at
    On-premise BYOD
    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,
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,434 Super User 2025 Season 1 on at
    On-premise BYOD
    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:

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,286 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans