Incremental Refresh with Dataverse

Hi, Anonymous 

You can use Incremental Refresh in conjunction with Dataverse.
To set up an incremental refresh table in Dataverse, first configure the table as you would any other table. After you have created and saved the data flow, select Incremental Refresh in the Table view. Note that using Incremental Refresh requires that the source data introduced into the stream has DateTime fields that can be filtered by Incremental Refresh.

As for connecting SharePoint to Dataverse, there are a few tutorials that can guide you through the process of integrating SharePoint with Dataverse. You can use Power Automate to synchronize lists from SharePoint to Dataverse. Once the data is in Dataverse, you can apply an incremental refresh.

However, please note that migrating from SharePoint to Dataverse is not a direct conversion. You will need to configure Dataverse tables to model the SharePoint list structure. After you configure the data model, you can export data from SharePoint lists and import it into Dataverse.

Related links:

Using incremental refresh with dataflows - Power Query | Microsoft Learn

How to Integrate SharePoint with Dataverse? - YouTube

Solved: How to sync lists from sharepoint to dataverse - Power Platform Community (microsoft.com)

Solved: SharePoint to Dataverse - Power Platform Community (microsoft.com)

If the above configuration process is difficult, you can try importing the data table directly into SQL Server using the incremental refresh strategy (note: the data should have DateTime columns, RangeStart and RangeEnd case, etc.)

Related link:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum