Forum Discussion
Getting error in Report Server while selecting an option "As User Viewing the report"
Looks like you haven't set up Kerberos authentication which you must do when authenticating with Windows credentials. Follow the guide here:
https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports
Workaround: select "Using the following credentials" and enter credentials of an account that has permissions on your data source (either Windows or SQL Server account).
Thanks for your reply.
The link which you shared provide details on "how to configure SPNs for Analysis service". Can you help me out how to do the same for the SQL server Database? We are using SQL direct Query .
Sure... follow the same steps as with analysis services but swap "MSOLAPSvc.3" with "MSSQLSvc".
Then remember to set delegation on the Report Server account for MSSQLSvc as well.
More details on setting SPNs for SQL Server here: https://technet.microsoft.com/en-gb/library/bb735885.aspx
Hi Arun,
can you please let me know if you are able to resolve this? If yes can you please help on how?
