Forum Discussion
Guidance Needed: REST API to Update Dataset for Power BI Paginated Reports
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
According to your guidence,
1. I can create new dataset
2. I can upload paginated report
But myconcern is how the report will bind with this dataset/semantic model?Mestu_Paul For Standard Reports we use the Rebind API to change the dataset / semantic model. But unfortunately the API does not support Paginated Reports
Thanks,
Jai
Yes thats the problem, even could not clone paginat report with different dataset
I also tried to clone paginated reports but getting error:
"error": {"code": "InvalidRequest","message": "Request is currently not supported for RDL reports"}
then isn't it possible to clone ?
