Publish RDL with service principal via API makes datasource stop working

[Anonymous]

Deploying an RDL via the PowerBI API works but when deploying using a Service Principal, the datasource in the reports no longer works until the user uses the 'Take Over' button. Uploading manually the exact same report in the GUI as the user works as expected. What can be done about this? It's essential in automated deployment scenarios to upload using SPs and the reports then need to work for all users who have rights to the workspace and reports.

[Anonymous]

I can confirm that this does in fact work fine as documented, the problem was mine and not constructing the API calls correctly.

[v-robertq-msft]

Hi, @Anonymous 

According to your description, I think you can refer to these links and check if they can be helpful:

https://dev.to/kenakamu/upload-rdl-file-s-to-power-bi-via-api-28h

https://community.powerbi.com/t5/Report-Server/Deploy-rdl-files-in-power-bi-report-server-web-portal/m-p/334181

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ef14b07f-8802-4f35-9270-608ee37d8354/apis-for-pbix-in-ssrs-service?forum=sqlreportingservices#88dc8ba9-fe4f-4dc1-a5eb-6adc5ed22ac5

Best Regards,

Community Support Team _Robert Qin

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