Incremental refresh for azure synapse with sql serverless pool

[bhuvi_123]

Hello

I have cosmos collection with updatedDate time filed in epochtime stamp format. I have enabled azure synapse for this with serverless sql pool. I want to do the incremental import on this. I followed the steps as mentioned in https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview, but it seems to be not working. I have these queries-

1) Is it correct to use updateTimestamp for RangeStart/RangeEnd and will it work as I need to create custom column which will have dateTime converted from this epoch. This column will be used for filtering.

2) Does this work with Azure synapse in this scenario? As I explored, I only see views. How partioning will work here, how I can verify it?

[PBILover]

Hi @bhuvi_123 

Have you got the answer for this? I have a same question.

[v-yanjiang-msft]

Hi @bhuvi_123 ,

About this topic, I found some related threads, please see if they can move you foreward.

Incremental Refresh Synapse - Reduce Number of Con... - Page 2 - Microsoft Power BI Community

Azure Synapse - Incremental Data Load - Stack Overflow

Incremental Processing for Fact Tables with Azure Synapse Analytics (mssqltips.com)

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.