topic Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files in Report Server

How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Thu, 05 Dec 2019 21:36:27 GMT

The subject is basically it. I would like to find a way to Copy all PBIX, RDL, Excel and PDF files from Production into a development.

Powershell or C# would be prefered/

Thanks,

Sam

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

d_gosbell — Thu, 05 Dec 2019 22:45:16 GMT

I would suggest you look at the ReportingServicesTools powershell module (see https://github.com/microsoft/ReportingServicesTools)

You should be able to use out-rsfoldercontent to copy everything from prod to a drive somewhere, then use write-rsfoldercontent to put those files back up to dev

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Wed, 11 Dec 2019 13:33:56 GMT

Thanks, I'll check it out.

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Wed, 11 Dec 2019 16:34:25 GMT

I've tried to use Out-RsFolderContent, but this is skipping Power Bi Files. Is there something I'm missing?

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Wed, 11 Dec 2019 16:56:50 GMT

I've also tried Out-RsRestFolderContent which appear to download PBIX files, but errors out on a linked report or anything that isn't in this list:

We only support items which are of type Report, DataSet, DataSource, Mobile Report or Power BI Report

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

d_gosbell — Thu, 12 Dec 2019 21:43:19 GMT

Anonymous wrote:

I've also tried Out-RsRestFolderContent which appear to download PBIX files, but errors out on a linked report or anything that isn't in this list:

We only support items which are of type Report, DataSet, DataSource, Mobile Report or Power BI Report

Sorry I checked our code and it was the out-rsrestfoldercontent cmdlet that we are using. But I also forgot that I actually manually patched our version so that it only writes a warning, not an error when it comes across an unsupported type.

if you are interested I've attached the file I patched where altered lines 85-94 to add a try/catch block. This file lives in the ReportingServicesTools\Functions\CatalogItems\Rest folder where ever you've installed the module.

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Fri, 13 Dec 2019 13:33:28 GMT

Thanks I'll give that a shot later today.

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Fri, 20 Dec 2019 16:27:11 GMT

Finally had some time and it's looking closer, but the updated version doesn't handle linked reports.

I would like to have those, but it would be ok if those are skipped.

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

d_gosbell — Fri, 20 Dec 2019 20:39:16 GMT

Yes, I just skipped the linked reports. There is no actual file format for those they, are just a record in the database. You could possibly look at building your own file by writing the data out as xml or json, but I'm not aware of anyone having done this already.

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Mon, 23 Dec 2019 14:53:48 GMT

Sorry I meant to say, when I get to a a folder with a linked report the script fails.

Just in case here's what I'm using:

#Out-RsRestFolderContent -RsFolder / -ReportPortalUri 'https://reports.site.com/Reports' -Destination C:\_TestingPBIRS -Recurse

Here's the error message:

Unsupported item type! We only support items which are of type Report, DataSet, DataSource, Mobile Report or Power BI Report

Thanks,

Sam

Re: How To keep Production and Development PBIRS on prem in sync. Move all RDL and PBIX files

Anonymous — Fri, 03 Jan 2020 19:29:28 GMT

I've found a way to skip linked reports, it's ugly though and I doubt they would want what I did on the github, but that brought up a new issue.

Do you by chance know of a Recurse way to upload. Looks like I have to go to each folder individually.