Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bhuvi_123
Employee
Employee

Incremental refresh for azure synapse with sql serverless pool

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?

1 REPLY 1
v-yanjiang-msft
Community Support
Community Support

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors