Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export of Dynamics NAV-data to Dataverse with minimum performance affect on a +340gb SQL-database


The increase of reporting accuracy and close to real-time analysis lead to new demands. Our current setup with is basically a replica of Dynamics NAV2017 SQL (onprem) which runs 1/night + plus some integrations to supporting programs databases via scripts. The database is restored every night, which takes approx 40 minutes, during that time no access is possible. The built in to in SQL doesn´t work for us. We like Powerplatform and look forward to more frequent data updates without affecting performance in NAV.

What would your setup be?



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.