Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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:
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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:
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
@rajulshah , there is blog , refer if this can help
https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/
This is Web API as data source. I am asking for the REST API to push rows into dataset.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
106 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |