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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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.
I have the same question (0)
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,477 Moderator on at
    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
  • Mohamad Barada(Scroll Up) Profile Picture
    Mohamad Barada(Scro... 8 on at
    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. 

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,371 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,806 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,371

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans