Incremental Refresh not working in Service

[_power_bi]

We have a Fabric datalake setup with a table there as a source in Power BI.  We also have an on-prem SQL Server as a source. I used the RangeStart and RangeEnd parameters  for incremental refresh on the fabric table and filtered the datetime column accordingly.  Then configured incremental refresh on the table in power bi desktop.   I can refresh locally without issue and it takes less than 10 minutes.  I publish to the service and the refresh spins for over an hour and then I got the error:

DM_GWPipeline_Gateway_InvalidConnectionCredentials

When I check under the gateway settings on the semantic model, the sources are there and are mapped correctly.  When I go to the gateway and click if those sources are online, they all show as online.  I'm not even sure if that error represents what is going on as a credentials error wouldn't take an hour to timeout.  

[_power_bi · Accepted solution]

I removed incremental refresh (right clicked on the table in the pbix and turned it off) and then saved a new pbix and published to my workspace.  It took about 20 minutes and refreshed. So, the issue is with the incremental refresh from a Fabric Lakehouse table. 

I noticed that when turning on incremental refresh in desktop, there is warning that it is unable to confirm if the query can be folded. (The query was a select * but it was a native query).  I removed that and simply connected to the table then filtered to the paramaters as before.  If you right click on the applied step (not the source step but any steps after), it should say 'view native query'.  If it doesn't allow you to click that, then it probably is not "foldable".  Again, I am not sure why the error was credential related. That threw me off. 

[v-achippa]

Hi @_power_bi,

Thank you for confirming that the issue is resolved now. So I request you to please accept the post as "Accept as solution" so that other community members will find it more quickly

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @_power_bi,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

The error indicates an issue with the gateway credentials. Since the refresh works in desktop but fails in the service, please follow below steps:

• In the service go to Settings --> Datasets --> Data Source Credentials and re-enter credentials for both Fabric Data Lake and on-prem SQL server and verify that all sources are correctly authenticated.
• Ensure that the on-premises data gateway is updated to the latest version to prevent compatibility issues.
• The column used for incremental refresh must be in datetime format (not string or other format).
• In the service go to Refresh History and check if there are any additional error messages beyond the credentials issue.

After performing these steps, try refreshing again. If the issue persists and failure is after exactly 70 minutes, it’s a known issue and as Ibendlin said we have a ticket open for the issue.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[lbendlin]

When you say "over an hour"  - is it 70 minutes?  Asking because we have a ticket open for a similar issue that comes up after eactly 70 minutes.

[_power_bi]

it was not 70 minutes. It was around 100 minutes before the error.