Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Dynamics NAV on-premis...
Small and medium business | Business Central, N...
Suggested answer

Dynamics NAV on-premises with Power BI Gateway incremental Refresh problem

(1) ShareShare
ReportReport
Posted on by Mohamad Barada(Scro... 8
I have Microsoft Dynamics NAV 2017 on-premises using SQL Server Database on-premise as well. I have pro license of Microsoft Power BI . I want to create a new report linked to several tables having large number of Records in Power BI, and I want to have the ability to make incremental Refresh in order to reduce the time of Refresh and also make automatic schedule for this incremental refresh everyday from 1am.
Please let me know if I can have incremental refresh with on-premise Microsoft Dynamic NAV 2017. Personally I tried it and couldn't make it happen. I was able to schedule automatic refresh (full refresh) but I was not able to make incremental refresh .
I was able to do automatic Incremental Refresh If I do connect directly with SQL Server.
  • Mohamad Barada(Scroll Up) Profile Picture
    Mohamad Barada(Scro... 8 on at
    Dynamics NAV on-premises with Power BI Gateway incremental Refresh problem
    I was able to do it without Premium license using the pro license but with connecting directly to SQL. 
    It was faster solution and I was able to configure the Incremental Refresh and make it possible without exposing the database online.

    I just wanted to see if anybody did it directly with Dynamics NAV because All worked well with direct connection with NAV but the refresh was too slow and I was not able to have the incremental refresh working. 
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,280 Super User 2025 Season 1 on at
    Dynamics NAV on-premises with Power BI Gateway incremental Refresh problem
    Hello,
     
    are you using DirectQuery? DirectQuery is only supported for Premium licences.
    We had a same problem with Power BI Pro licence where we thought that Pro will be enough for Incremental refresh but we did not have a success.
     
    I hope that you got to this link, but just in case you have more details on the link below 
     
    Greetings

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,138 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,895 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans