My data source is on another server, SQL Server 2014 instance, and this data source does not work with Integrated Windows Security. I don't get to the point of executing queries as I am getting errors at the time of setting up the data source.
The same database after porting into SQL Server 2016, works fine where SQL Server & SSRS are on the same box.