SSRS Subscription Problem

Hi SQLJiim 

The error you're encountering in SSRS 2019, "System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.Cloud.DataExtensions'," indicates that the SSRS instance is attempting to use a cloud-related data extension that is either missing or improperly configured. This assembly is part of the extended functionality for integrating cloud data sources into SSRS reports. The error suggests that the required assembly is not found in the expected location on your file system.

To fix this issue, you will need to obtain the missing assembly, which is typically part of the SQL Server Reporting Services (SSRS) or SQL Server Data Tools installation. You can resolve this by ensuring that all necessary SSRS components are installed correctly, especially any components related to cloud data sources. Check if you need to install additional data extensions or features through the SQL Server installation center. In some cases, reinstalling or updating SSRS with the latest service packs or patches may resolve missing dependencies. If you're using any cloud-based data sources (like Azure), ensure that the corresponding extensions for those sources are properly installed. Additionally, you can manually search for the missing file or download the required extensions from official Microsoft sources.