"As the user viewing the report" in powershell

[DuncanYeah]

Hi all,

I am working on changing the dashboard connection in Report Server by powershell squirt . However, i cannot change the Credentails to "As the user viewing the report".

What should the $dataSource.DataModelDataSource.AuthType should be in order to get "As the user viewing the report".

Thank You.

Duncan

[Anonymous · Accepted solution]

Hi, @DuncanYeah 

You can open your Report server web portal and press F12 to enter the developer mode of the browser. Then, configure a data source for a random report. In the developer tools, you can see that when we need to use: As the user viewing the report, the authorization type passed by the powershell command is Integrated.

{
    "Type": "Live",
    "Kind": "XXX",
    "AuthType": "Integrated",
    "SupportedAuthTypes": [
        "Integrated",
        "Impersonate",
        "Windows",
        "UsernamePassword"
    ],
    "Username": "",
    "Secret": "",
    "ModelConnectionName": ""
}

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.