- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
PBIRS issue updating shared datasource of a report
Hello,
I am trying to automate rdl file deployments to our power bi report server via the APIs https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0
If the report already existed on the report server i am able to update it and update its data source as well.
If the report is new, that is, it did not exist previously on the report server I am able to post it to the report server using https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/Reports/AddReport
But I am facing an issue trying to update its shared data source using the API https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/Reports/SetReportDataSource
after much looking around i realized that i needed to send the entire body of the expected json, i had assumed it will only require the fields that needed to be updated
but to no avail it still throws a bad request.
I have also tried using the reporting service tools but
throws $item does not contain a dataSource reference
so i tried to get the data source of the report via the api https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/Reports/GetReportDataSources and saw that the is reference property is set to false, assuming that is casuing the reporting service tools to fail i tried to update that property via the api https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/Reports/SetReportDataSource
but it still throws 400 bad request. I am stuck, here is a visual representation of what i am trying to do
when we upload a new report this is what we see
but we dont want a custom data source i want to via APIs or the reporting service tools select the shared data source button
click on browse and and select a data source from the report server.
any help is appreciated.
Thankyou

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
4 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
7 | |
6 | |
5 | |
4 | |
3 |