This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Hi Mohamad Barada,
Thank you for reaching out to us on Microsoft Q&A forum.
Can you please specify the Learn Path/Module that you are going through?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 13%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Hi Mohamad Barada,
Thank you for reaching out to us on the Microsoft Q&A forum.
This topic is currently not supported in the Q&A forums.
I recommend initiating a new discussion through the https://community.dynamics.com/
Moderators are readily available there to assist you and provide guidance.
Please don't forget to Accept helpful answer and close this thread.
This topic is mentioned here. I didn't find the proper tag but I believe the Incremental Refresh for Dynamics is a common subject between Power BI and Microsoft Dynamics.