I am calling excel Handler to call a Reporting Service Report directly from the Report Link like this:
var MySheet= ExcelHandler.Workbook.Worksheets.Add();
MySheet.Name = MyDataSheet;
string webcn =
$@"https://www.abcz.com?ReportPage&reportid={reportId}&template=123&ReportId=123";
MySheet.QueryTables.Add(Connection: "URL;" + webcn, Destination: MySheet.Cells[1, 1]);
Earlier this code was working fine. But now in my application Single Sign On is implemented. After that it is not working. May be due to Authentication. Is there any way we can call this Report by passing Authentication Id and Pwd.
