After upgrading the SQL Server Reporting Service to 2016, the SSRS reports embedded in different applications including SharePoint pages using an iframe tag or page viewer web parts were stopped rendering.

SSRS SQL Server

How to create SSRS reports by joining multiple SharePoint List columns with foreign key relationship

SharePoint SSRS

When you create Dataset using SharePoint List as datasource the list columns includes duplicate records. There is no direct way to remove duplicates and get only the distinct values.

SharePoint SSRS