ADO task for Paginated Reports update data source

[Anonymous]

I am working on creating a CI/CD pipeline in azure devops for the paginated reports to automates the reports deployment in PowerBI workspace.

I am using the "PowerBI Action" task in the yml code. This task doesnt support updating the data source connection for the paginated reports. I don't see anyother task which supports rdl reports.

Do we have any task in ADO for updating the data source connection string for the Paginated reports?

Thanks in advance.

[DileepRajam]

Hi @Anonymous are you able to update the connections for paginated reports using DevOps? If yes, can you please guide me with directions

[Anonymous]

Hi @DileepRajam,

You can use REST API Reports - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn to update the datasource connections using the PowerShell task in Devops.

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

Maybe you can try REST API to refresh the dataset of this paginated reports.

Datasets - Update Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the reply @v-chenwuz-msft 

Since we are working on the paginated reports, we don't have a dataset.

I will give it a try with https://docs.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources