Forum Discussion
ADO task for Paginated Reports update data source
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.
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.
4 Replies
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.
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
Hi Anonymous are you able to update the connections for paginated reports using DevOps? If yes, can you please guide me with directions
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.
