Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a list of 40 Report IDs in the Power BI service that point to a defunct DatasetID.
I need to change the DatasetID for all 40 of them.
Can this be done with the API?
Bonus question: What if some of the reports are in users' "My Workspace"?
Thanks for looking!
Solved! Go to Solution.
You can try Rest Api as below to change data source for your reports.
Important: The original datasource and the new datasource must have the exact same schema.
Required scope: Reports.ReadWrite.All
Restrictions:
My workspace:
For reference: Reports - Update Datasources
POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/Default.UpdateDatasources
Specific workspace:
For reference: Reports - Update Datasources In Group
POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/Default.UpdateDatasources
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I need the same thing. After a quick test, I think https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreportingroup and https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreport does the trick.
You can try Rest Api as below to change data source for your reports.
Important: The original datasource and the new datasource must have the exact same schema.
Required scope: Reports.ReadWrite.All
Restrictions:
My workspace:
For reference: Reports - Update Datasources
POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/Default.UpdateDatasources
Specific workspace:
For reference: Reports - Update Datasources In Group
POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/Default.UpdateDatasources
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-rzhou-msft but I was looking for something that works on PBIX reports.
I need the same thing. After a quick test, I think https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreportingroup and https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreport does the trick.
Thanks @Anonymous ... I agree it looks like the best we can do.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
2 | |
2 | |
2 |