Incremental Refresh and REST API together

[rajulshah]

Hello,

Can anyone guide me that is it possible to use Incremental Refresh for a dataset and also use REST APIs to delete/insert data in the dataset?

Also, are there any restrictions that we can use REST APIs (Push dataset) only for the Streaming Datasets? 

Please guide.

Can you guys please help? @Greg_Deckler @parry2k @mwegener @v-lionel-msft 

Thanks in advance.

[mwegener · Accepted solution]

Hi @rajulshah ,

the API functions only work with Push dataset (streaming dataset or datasets + tables created through the API)

Unfortunately it is not possible to create a data model with relationships etc. with this.

https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_postrowsingroup

Power BI REST API limitations:

https://docs.microsoft.com/en-us/power-bi/developer/automation/api-rest-api-limitations?redirectedfr...

[amitchandak]

@rajulshah , there is blog , refer if this can help

https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/

[rajulshah]

@amitchandak ,

This is Web API as data source. I am asking for the REST API to push rows into dataset.