Can't Update paginated report data source of as semantic model using rest api

[Mestu_Paul]

I've created a paginated report by power bi report builder. Used power bi semantic model as data source then published it on power bi service. After that I cloned report by REST API.

Now I want to change the data source as another semantic model of cloned report. I also tried by this endpoint

POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/Default.UpdateDatasources

Payload :

Payload

{
  "updateDetails": [
    {
      "datasourceName": "<dataSourceName>",
      "connectionDetails": {
        "workspaceId": "<workspaceId>",
        "datasetId": "<datasetId>"
      }
    }
  ]
}

The request return success but actually the report doesn't show data from updated semantic model. I'm looking for an approach to update the data source as semantic model.

I read the Reports - Update Datasources documentation to update paginated repot's data source  but there no example to upate semantic model as data source

[v-aatheeque]

Hi @Mestu_Paul ,
Thanks for reaching out to Microsoft fabric Community Forum.

1. To update the data source of a paginated report using a new semantic model via the Power BI REST API,
2.Ensure the workspaceId and datasetId are correct in the API payload, and verify that the dataset schema is compatible with the report.
3.If issues persist, check for caching or schema mismatches. If the update is not reflected, try refreshing the dataset or manually reconfiguring the data source in the Power BI service.

If you encounter any issues, please share a screenshot of the error for better understanding.

Did I answer your question? Then please mark my post as the solution.

If I helped you, click on the Thumbs Up to give Kudos.

[Mestu_Paul]

@v-aatheeque thanks for your response.

I tried in different way and successfully updated report data source. But arise another problem after change the datasource as another semantic model, I can't export the report.

Api response error: 

exporting a paginated report requires permissions in both report and dataset workspaces

I ensured the the report and dataset belong in same workspace and I could not find any solution to export this report. 

[v-aatheeque]

Hi @Mestu_Paul ,

To export a paginated report in Power BI, you need the following permissions:

• Power BI Pro license or Premium Per User (PPU) license to publish your paginated report.
• If the paginated report is based on a dataset that resides in a different workspace, you also need to have the necessary permissions (usually "Build" or "View") on that dataset's workspace. This is important because the paginated report relies on the dataset to generate the report content.
• You can create a paginated report in Power BI Report Builder without a license, but to publish it, you need at least a Contributor role in the workspace.
• Additionally you refer the below links for reference :Publish a paginated report to the Power BI service - Power BI | Microsoft Learn
  Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn
  
  

  If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
   
  if still you have problems on it please feel free to let us know !
   

  
  
  

[Mestu_Paul]

I've all permissions and the export functionality is working for power bi report even working for paginated report which are publish from power bi report builder.

But when I change the datasource as another semantic model, then the error occur. I ensure the all report and dataset in same workspace

[v-aatheeque]

Hi @Mestu_Paul ,

Thank you for reaching out regarding the export issue you're experiencing with your paginated report after changing the data source to a new semantic model.

Here are some steps you can take to troubleshoot the issue:

• Open the report in Power BI Report Builder. Navigate to the Data Sources section and ensure that the connection string is correctly pointing to the new semantic model (dataset). Test the connection to confirm that it is working properly.
• When changing to a new semantic model, ensure that the structure (tables, fields, measures) aligns with what your paginated report expects. If any fields or measures referenced in the report do not exist in the new model, this could lead to errors during export.
• Even if both the report and dataset are in the same workspace, you may need to explicitly rebind the report to the new dataset. This can be done using the Power BI REST API. Here’s a helpful link for reference: Rebind Report - Power BI REST API.
• After rebinding, ensure that the dataset is refreshed so that the latest data is available for export. You can trigger a manual refresh in the Power BI Service or use the Refresh Dataset API.

If you still encounter any issues, please share a screenshot of the error for better understanding.
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-aatheeque]

Hi @Mestu_Paul 

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Mestu_Paul · Accepted solution]

Hi @v-aatheeque ,

First of all I am sorry that I could not response you.
I got the solution here I am going to describe about that. 
There was a issue for payload structure. Actually I tried in this way

{
  "updateDetails": [
    {
      "datasourceName": "<dataSourceName>",
      "connectionDetails": {
        "server": "Data Source=powerbi://api.powerbi.com/v1.0/myorg/<workspaceName>",
        "database": "<datasetName>"
      }
    }
  ]
}

And report can pull data from specific dataset/semantic model. But arise problem while trying to export, it was showed me error :

exporting a paginated report requires permissions in both report and dataset workspaces

Then I compare with a main report's datasource by REST API where I connect a semantic model by power bi report builder which was able to export report. And I could identify the issue , I change the payload structure according the main report. Here the updated and working payload:

{
  "updateDetails": [
    {
      "datasourceName": "<dataSourceName>",
      "connectionDetails": {
        "server": "pbiazure://api.powerbi.com/;",
        "database": "sobe_wowvirtualserver-<datasetId>"
      }
    }
  ]
}

 Then I can successfully export the report using REST API.

--------------------------------------------------------------------------------------------------------
As far as I know , paginated report have no feature to rebind with semantic model. Its possible to update data source

[v-aatheeque]

Hi @Mestu_Paul ,

Glad that your query got resolved and If our response addressed by the community member for your query,If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for being a part of the Microsoft Fabric Community Forum!