Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Deepthi
Frequent Visitor

On premises Data Gateway registration fails - "Profile for the user is a temporary profile"

Hi,

 

Just installed the On Premises Gateway for PBI and the follwing error occurs when trying to register. The installation has been successful. Please find snapshot attached. 

PBI_Gateway_RegFailure.PNG

Error generating an asymmetric key.
The profile for the user is a temporary profile.


Server stack trace: 
   at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.PowerBI.DataMovement.Pipeline.InternalContracts.IGatewayConfigurationService.GenerateAsymmetricKey()
   at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GenerateAsymmetricKey()An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.Security.Cryptography.CryptographicException: The profile for the user is a temporary profile.

   at System.Security.Cryptography.Utils.CreateProvHandle(CspParameters parameters, Boolean randomKeyContainer)
   at System.Security.Cryptography.Utils.GetKeyPairHelper(CspAlgorithmType keyType, CspParameters parameters, Boolean randomKeyContainer, Int32 dwKeySize, SafeProvHandle& safeProvHandle, SafeKeyHandle& safeKeyHandle)
   at System.Security.Cryptography.RSACryptoServiceProvider.GetKeyPair()
   at System.Security.Cryptography.RSACryptoServiceProvider..ctor(Int32 dwKeySize, CspParameters parameters, Boolean useDefaultKeySize)
   at Microsoft.PowerBI.DataMovement.CommonUtilities.AsymmetricKeyEncryptionHelper.ProduceAsymmetricKey(String containerName)
   at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)
   at SyncInvokeGenerateAsymmetricKey(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

 

Any support will be greatly appreciated.

 

Thank you,

Deepthi.

2 ACCEPTED SOLUTIONS
v-qiuyu-msft
Community Support
Community Support

Hi @Deepthi,

 

Based on my research, the issue can be caused by that PBIEgwService user was not being installed properly, you can try to delete the User folder and the registry keys for this user and reattempted the install. Please refer to this similar thread: Problems installing both gateways.

 

Also you can try to change the logon user for Service "On-premises data gateway service" (PBIEgwService) to "Local System Account. Please see eliezer 's reply in this thread: Power BI Gateway - Enterprise - Error generating an asymmetric key.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @Deepthi,

 

How about the result after try my suggestions? If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Mamerion
Frequent Visitor

okey dokey...

in my case it was due to inappropriate Uninstallation....

when you install the Gateway, it creates a user profile called “PBIEgwService” in “C:\Users”.

When you uninstall the gateway to replace it with the latest version, you gonna make sure that

  • All related folders are deleted. (“C:\Program Files\On-premises data gateway”)
  • most improtantly, the PBIEgwService user profile entry in windows registry is also deleted. Here is where I spent 4 hours to figure out where the entry sits. The registry entry for gateway user profile to be located at “[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\S-1-5-80-1835761534-3291552707-3889884660-1303793167-3990676079]”

 

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\S-1-5-80-1835761534-3291552707-3889884660-1303793167-3990676079]
"ProfileImagePath"=hex(2):43,00,3a,00,5c,00,55,00,73,00,65,00,72,00,73,00,5c,\
  00,50,00,42,00,49,00,45,00,67,00,77,00,53,00,65,00,72,00,76,00,69,00,63,00,\
  65,00,00,00
"Flags"=dword:00000000
"State"=dword:00000204
"Sid"=hex:01,06,00,00,00,00,00,05,50,00,00,00,7e,7f,6b,6d,c3,1b,31,c4,f4,ed,da,\
  e7,0f,4e,b6,4d,6f,e2,dc,ed
"ProfileAttemptedProfileDownloadTimeLow"=dword:00000000
"ProfileAttemptedProfileDownloadTimeHigh"=dword:00000000
"ProfileLoadTimeLow"=dword:00000000
"ProfileLoadTimeHigh"=dword:00000000
"RefCount"=dword:00000001

If this entry remains in registry once you uninstalled the software, it prevents the new installation from createing the “PBIEgwService” user profile; instead it will create a TEMP user profile which will not necessarily have permission to connect to the Internet on the server to talk to PowerBI Services. Hence, not allowing you to config your gateway.

 

delete this entry, re-start the machine, then try to install the package and it should be all good Smiley Very Happy

 

 

v-qiuyu-msft
Community Support
Community Support

Hi @Deepthi,

 

Based on my research, the issue can be caused by that PBIEgwService user was not being installed properly, you can try to delete the User folder and the registry keys for this user and reattempted the install. Please refer to this similar thread: Problems installing both gateways.

 

Also you can try to change the logon user for Service "On-premises data gateway service" (PBIEgwService) to "Local System Account. Please see eliezer 's reply in this thread: Power BI Gateway - Enterprise - Error generating an asymmetric key.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks Qiuyun, i will give it a go .

Hi @Deepthi,

 

How about the result after try my suggestions? If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Qiuyun,

 

Thanks a ton for your help and sorry for not responding earlier.

 

Of the 2 solutions you provided, eliezer's did the trick.

 

"Change the logon user for Service "On-premises data gateway service" (PBIEgwService) to "Local System Account"

 

I have marked you Post as solution. Bril 🙂 Cheers !

 

Deepthi

This worked for me as well, thanks so much! You saved the day. 🙂

"Change the logon user for Service "On-premises data gateway service" (PBIEgwService) to "Local System Account"

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors