topic Re: migrating subscriptions from ssrs integrated to native mode report server in Report Server

migrating subscriptions from ssrs integrated to native mode report server

IbisRipley — Mon, 03 May 2021 21:08:02 GMT

I am using RS.exe to migrate SSRS reports from integrated sharepoint to pbi report server. The source reports access sharepoint and use integrated security. The unnatended execution account is set up on the destination server. The subscriptions error with -->"The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified."

My Question is, Is there any pre-work or settings I can use to copy the subscriptions? Even if I have to change a config after? The problem is that when they fail, we have to create them manually ( to/from/params/schedule ..) So if there was any thing I can do to at least get them to be copied even if they don't work it would save tons of time.

thanks in advance for any advice.

Sean

Re: migrating subscriptions from ssrs integrated to native mode report server

Icey — Thu, 06 May 2021 07:50:54 GMT

Hi IbisRipley ,

Please check if reportsync could meet your requirements. There is a PowerShell command named Copy-RsSubscription.

Copy-RsSubscription

This command adds a retrieved subscription to an existing report. For use with Get-RsSubscription.

Reference: Solved: Move SSRS reports to existing PBIRS - Microsoft Power BI Community

Best Regards,

Icey

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

Re: migrating subscriptions from ssrs integrated to native mode report server

Icey — Tue, 25 May 2021 09:07:06 GMT

Hi IbisRipley ,

Can the above method work in your scenario?

Best Regards,

Icey