Small and medium business | Business Central, N...

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

(1) Share

Report

Posted on by Mohamad Barada(Scro...

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)

All responses (2)

Answers (0)

Suggested answer

Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (2)

Report

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

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Greetings

Was this reply helpful? Yes No
Mohamad Barada(Scro... 8 on at

Like (3)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates