topic Re: Exception "cannot resolve UPN for user xxx" on non-domain user in Report Server

Exception "cannot resolve UPN for user xxx" on non-domain user

oduis — Mon, 28 Jan 2019 17:56:50 GMT

Situation

A local developer machine with freshly installed PowerBI Report Server Jan19 plus Desktop Jan19. Machine is not in a domain, local user account. I can open the portal via browser and publish a report (local CSV source) via PBI Desktop, but when I enter the report in the browser all visuals show "Unexpected error".

The RSPowerBI log file contains an error "Cannot resolve UPN for user xxx", but it is a local user, having no UPN. The setup worked with the August release wie IE (when configuring Negotiate as authentication), but not in Jan19 it seems.

Any help appreciated.

Oliver

2019-01-28 18:44:05.7036|ERROR|10|GetDataSource ERROR for catalogItem=34d32060-4495-438d-8dac-71f445c5ba9e, Exception=Cannot resolve UPN for user NEMESIS\oduis, ElapsedMs=145| RequestID = 1495af48-f888-5bdf-0b44-72cc3e8efce8 ClientSessionID = 3f19a923-5f53-1d59-6cf5-6b989db3b603 2019-01-28 18:44:05.7036|ERROR|28|Failure in conceptualschema| RequestID = 1495af48-f888-5bdf-0b44-72cc3e8efce8 ClientSessionID = 3f19a923-5f53-1d59-6cf5-6b989db3b603 System.Exception: Cannot resolve UPN for user NEMESIS\oduis bei Microsoft.PowerBI.ReportServer.WebApi.ASConnection.RSDataSourceProvider.GetDataSource(Int64 modelId) bei Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewDataSourceProvider.GetDataSourceInfo(String modelIdFromClient, RSDataSourceConnection& rsDataSourceConnection, IASConnectionInfo& asConnectionInfo) bei Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.CreateModelKeyFromId(String modelIdFromClient, String maxModelMetadataVersion) bei Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.EnsureSession(String modelId) bei Microsoft.PowerBI.ExploreHost.ExploreClientHandlerBaseFlow.b__8_0() bei System.Threading.Tasks.Task.Execute()

Re: Exception "cannot resolve UPN for user xxx" on non-domain user

chrisfin — Mon, 28 Jan 2019 19:42:27 GMT

Are you using a DAX username() function at all for this dataset?

Re: Exception "cannot resolve UPN for user xxx" on non-domain user

oduis — Mon, 28 Jan 2019 19:47:37 GMT

No, not a all. No RLS either. Pretty simple CSV merging and display, no user context.

Re: Exception "cannot resolve UPN for user xxx" on non-domain user

vvnck — Tue, 29 Jan 2019 01:48:08 GMT

I got the same issue after update to jan 2019. it occured on the report server non-ad install. those instance installed in AD work well.

MS please help.

Re: Exception "cannot resolve UPN for user xxx" on non-domain user

Anonymous — Tue, 29 Jan 2019 05:43:38 GMT

Same situation here...

Re: Exception "cannot resolve UPN for user xxx" on non-domain user

Anonymous — Thu, 31 Jan 2019 16:06:24 GMT

New release (01.30.) solved our issue which was the same as yours. Try it out!

Re: Exception "cannot resolve UPN for user xxx" on non-domain user

oduis — Thu, 31 Jan 2019 16:13:20 GMT

Thanks for the tip, Matt! Works like a charm now.