Push Datsets using Power BI REST API

Hi bhavana_dfz ,

Thank you for reaching out to Microsoft Fabric Community.

Yes, the Push Datasets API (PostDataset) is typically used for real-time scenarios and does not support features like scheduled or incremental refresh, as those rely on a connected data source. Push datasets are "streaming" in nature, so once data is pushed, it stays in Power BI and isn't reloaded from the original source.

In order to meet your requirement:

1.A dataset connected to Azure SQL Database

2.Support for Incremental Refresh

3.The ability to trigger refresh manually via API or Power BI Service

You should not use Push Datasets. Instead you can try below recommended steps:

a.Create the dataset in Power BI Desktop:

Connect to Azure SQL Database

Enable Incremental Refresh via parameters and filters in Power BI Desktop

Publish this dataset to the Power BI Service

b.Schedule or Manually Trigger Refresh:

Use the Power BI REST API: Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Or use the Power BI UI to refresh the dataset

• The REST API (PostDataset) you're referencing creates datasets without data source bindings, so they can't access external data sources like Azure SQL or support refresh/incremental logic.
• If you're looking to automate dataset creation with external sources, consider using XMLA endpoints, Power BI Deployment Pipelines, or Tabular Editor with TOM scripting.

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! 

Thank you.