• Yes, you can right click on the report and go to its properties. There you can define a fixed credential which will be used everytime the report is run.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP