Forum Discussion

DuncanYeah's avatar
DuncanYeah
Icon for Helper III rankHelper III
1 year ago
Solved

"As the user viewing the report" in powershell

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

"Power BI Report Server "
"Power BI Report Server"
Need Help
Power BI PowerShell
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.