Guidance Needed: REST API to Update Dataset for Power BI Paginated Reports

[Mestu_Paul]

Hello Team,

I have a question regarding Power BI Paginated Reports and how to manage datasets via the REST API.

In Power BI Report Builder, a semantic model is used as the data source, and then we create a dataset from that data source. According to the documentation , we can update the data source of a paginated report via the REST API. However, I am unclear on how to sync the dataset with the updated data source through the REST API.

Context:

I am building a solution where I create a dataset/semantic model for each user, and then clone the Power BI report using this dataset via the REST API. I want to extend this process to Power BI Paginated Reports as well—creating a new dataset with the same schema and then cloning the paginated report with the new dataset. The challenge I’m facing is that paginated reports use a semantic model as their data source, which adds some complexity to the dataset synchronization.

Could anyone help clarify how to achieve this with the REST API?

Thank you for your time and support!

[Mestu_Paul · Accepted solution]

I've got the solution to update data source as power bi semantic model.
Here is the solution 

[Anonymous]

Hi @Mestu_Paul,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Answer" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Thanks,
Pavan.

[tharunkumarRTK]

@Mestu_Paul 

I believe this API can help you accomplish the task, i.e updating the datasource of a Paginated report (RDL).

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources-in-group

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[Mestu_Paul]

Thank you, but already I read and actually confused about data sources and dataset of paginated reports. 

rajendraongole1 told me a solution, I will try it.

[Jai-Rathinavel]

@Mestu_Paul Does each user have access to different datasources ?

[Mestu_Paul]

Actually we embed reports for each user with users specific data thats why we need different dataset for each user.

[rajendraongole1]

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

[Mestu_Paul]

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 ?

[Mestu_Paul]

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?

[Jai-Rathinavel]

@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

[Mestu_Paul]

Yes thats the problem, even could not clone paginat report with different dataset