This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(249.60000000000002, 62%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
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?
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hi @Bhuvnesh Kumar ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
![](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(278.4, 76%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
hi @Bhuvnesh Kumar , have you resolved this? I have same question
Hi @Bhuvnesh Kumar ,
Thank you for posting query in Microsoft Q&A Platform.
Could you please clarify little more on, What you mean, when you say enabled azure synapse with serverless SQL pool for cosmos? You mean you are loading cosmos data in to some table? Server less SQL pools won't have tables actually. Kindly share more details on this please?
If you are looking for something loading data into Azure Synapse table, then you need to consider using Dedicated SQL pool inside Azure Synapse Analytics.
It seems the link which you are referring is related to Power BI. Microsoft Q&A is a platform for Azure related services. Below link is for PowerBI community platform. Kindly feel free to use that.
https://community.powerbi.com/
Hope this helps. Please let me know if any queries.
----------------
or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Azure cosmos bydefault provide option to enable azure synapse link. When we enable it for any collection in cosmos, all the update/delete/add operation gets synced to azure data lake. It also create one serverless sql pool, which provide support to query data in azure data lake using T-SQL queries.