Backup Reports on Saas

Looking for a solution similar to Solution Workbench for backing up reports/RDDs/RDLs/BAQs. Solution Workbench is not available to me. Any other suggestions?

Long way would be to export everything manualy thru “Action” tab :confused:

I could build it, but I’m gonna need a lot of snacks and beer.

What version did solution workbench come in?

:laughing:
I’m not entirely sure. I am on-prem but helping a SaaS user - I’m like oh this will be easy. Sure enough, Solution Workbench doesn’t exist.

This kind of ties in with my other topic:

MT can have solution work bench, you just aren’t allowed to have it. They enabled it when we were transferring off MT so we could export our stuff

Is that something we can request? The goal is to backup all the custom reports just in case. Seems like a good idea… I’m open to other ideas.

Do you have these enabled on your User Account?

So confused right now :confused: :confounded:

Why does a SaaS customer need to back up their reports? Isn’t that the whole reason to go SaaS?!?!?!?

I believe it’s the fear of something breaking with the regular updates. I guess I could ask… I really don’t know the pros and cons of Saas.

Psst. Psst. Did you know if you keep reports in source control, you don’t have to back them up. Pass it on.

secret GIF

1 Like

If they have uploaded a custom report properly, and it breaks on an upgrade, they will still be able to download the RDL. It will just error out on running.

1 Like

Sometimes the BAQ client shoves a BAQ through a meat grinder on save. Sometimes I make a change in SSRS that breaks something and don’t have a clean rollback path. Mostly I have an allergy to doing development on production assets when users have feature requests.

I’m with Mark! I have a git repo that contains every SSRS report I’ve touched, with BAQ and RDD backups alongside each. Git has saved my bacon more times than I can count.

2 Likes