Establish Connectivity to Microsoft SSRS
This article details how to connect to Microsoft SSRS to build Elements in Metric Insights.
- Specific user roles must be enabled on both SSRS UI and server side. See instructions below.
- SSRS 2019 15.0.7243.37714
NOTE: Versions outside of this list may be supported but are not actively tested. If you have an older or newer version, please work with [email protected] so that we understand your requirements.
Access <SSRShostname>/Reports/browse > Manage Folder
The service account requires the "Browser" role
Access Admin > Collection & Storage > Data Sources
- [+New Data Source]
- Choose "Microsoft SSRS" from the Other drop-down list
- [Next Step]
- Set a descriptive Data Source Name
- Provide Report Server URL for accessing the SSRS reports
- Specify the host name of the SSRS Server
- Enter Username and Plugin Password
Optionally, toggle on Enable On-Demand Element Creation
Enter a domain if SSRS login requires it
Include Reports history snapshots
||Set to "true" to include History Snapshots (versions) of SSRS Reports on Dataset Object List
Include Policies as dataset
||Set to "true" to include itemType, report, userGroupName, and roles to a separate #Metadata folder on Dataset Object List
Include Policies in report metadata
Set to "true" to include itemType, report, userGroupName, and roles in external_report_reference
Include Sub Reports
||Set to "true" to return Tablixes of Reports as separate objects to Metric Insights
Specify if you want to use specific SSRS folders only
Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.
Click [Test Connection] in the upper right corner