Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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
development
Production
Sync
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago
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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks I'll give that a shot later today. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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. 

    • d_gosbell's avatar
      d_gosbell
      Icon for Super User rankSuper User
      6 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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