Forum Discussion
Change Paginated Report Dataset programatically
- 1 year ago
bradsy v-hashadapu
Sorry on my latency.Keeping the same datasourceName didnt help. I get now the following error:
| One or more errors occurred. ({ "code": "InvalidRequest", "message": "Rdl UpdateDatasources updateDetails should not contain duplicated datasource Id's" })
Invoke-PowerBIRestMethod -Url $endpoint -Method POST -Body $body
| Encountered errors when invoking the command: { "code": "InvalidRequest", "message": "Rdl UpdateDatasources updateDetails should not contain duplicated datasource
| Id's" }Mind you that if I put the same datasourceName how does it knows how to switch ?
To mention that the paginated report sits in a workspace(call it workspace1) and is connected to a dataset from another workspace (call it workspace2). What I want is to reconnect the paginated report to a dataset from another workspace( call it workspace3).
The service Principal is the admin of the workspaces.
Hi ducky , thank you for reaching out to the Microsoft Fabric Community Forum.
As mentioned by bradsy, One should Keep the datasourceName the same as it exists in the paginated report and update the connectionDetails to point to the new data source.
Try it and If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.