Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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:
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |