Forum Discussion
Guidance Needed: REST API to Update Dataset for Power BI Paginated Reports
- 1 year ago
I've got the solution to update data source as power bi semantic model.
Here is the solution
Hi Mestu_Paul - The key to syncing the dataset with the updated data source for a paginated report is the Update Datasources API. By remapping the existing data source of the paginated report to the newly created dataset (semantic model), you can ensure that the report stays in sync.
If you are generating a unique dataset (semantic model) for each user:
Use the Power BI REST API to clone a dataset or create a new one programmatically.
Endpoint: POST /groups/{groupId}/datasets
If cloning, use: POST /groups/{groupId}/datasets/clone.
2. Upload or Clone the Paginated Report
Once the dataset is ready, upload or clone the paginated report:
Endpoint to upload: POST /groups/{groupId}/imports.
To clone a report: POST /groups/{groupId}/reports/clone.
Imports - Post Import In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Reports - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
I also tried to clone paginated reports but getting error:
then isn't it possible to clone ?