Forum Discussion
Getting error in Report Server while selecting an option "As User Viewing the report"
Hello, I have built a report using Direct Query(SQL Server) . While deploying report in Report server, i have used an option "As User Viewing the report" instead of providing the default credentia...
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 .