search

microsoft / ReportingServicesTools

Reporting Services Powershell Tools
MIT License
457 stars 213 forks source link

After writing folder to SSRS, Datasets and Data Sources Cannot be Found #340

Open jbruneFei opened 3 years ago

jbruneFei commented 3 years ago

I downloaded files from one SSRS folder, DEV, and then uploaded to another folder, QC. None of my reports will run in QC. I get the errors "We can no longer find this dataset. If it was moved, choose it from its new location." or "We can no longer find this data source. If it was moved, choose it from its new location." I have 100s of reports and shared datasets. SSRS Server is SQL 2017.

Here is my code

Out-RsFolderContent -RsFolder "/MyDev" -Destination "C:\Temp\ssrs\MyDev" -ReportServerUri  "$($ssrsServer)/ReportServer_SSRS/ReportService2010.asmx?WSDL" -Recurse

Write-RsFolderContent -Path $SourcePath -ReportServerUri $ReportServerUri -DestinationFolder "$RootFolder"  -Recurse  -Overwrite
mikeyd85 commented 3 years ago

I've not used this tool yet (having only discovered it today), however after deploying with RS.exe, this is quite a common issue.

Can you use Set-RsItemDataSource to set the data-source for each of your deployed RDLs?