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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Gateway data source setting Error

Hi , I'm encountering an issue with date source setting. When I added one data source in dataset, it shows below error.

I'm sure that the username and password is correct, domain/username with password. 

What's the meaning of "the parameter is incorrect" ? I don't have any parameter in the dataset. 

1.png

 

Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@v-easonf-msft , 

 

Sorry for the late response. This issue has been resolved and thanks for the support from Microsoft team. 

 

Here is the step which fixed the issue. 

 

1. change the service account from default PBI service account to local system account.
2. restart the service in on-premised gateway.
3. restart the on-premised gateway and re-register your account. Migrate the existing gateway cluster to the new registered gateway.
4. add the data source to the gateway connection again on cloud.

 

But I'm not sure about the root cause. At least this issue has been resolved :). 

 

Thanks!

View solution in original post

12 REPLIES 12
v-easonf-msft
Community Support
Community Support

Hi ,  @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please add your reply  and mark it as Answered to close this thread.
More people will learn new things here.

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

@v-easonf-msft , 

 

Sorry for the late response. This issue has been resolved and thanks for the support from Microsoft team. 

 

Here is the step which fixed the issue. 

 

1. change the service account from default PBI service account to local system account.
2. restart the service in on-premised gateway.
3. restart the on-premised gateway and re-register your account. Migrate the existing gateway cluster to the new registered gateway.
4. add the data source to the gateway connection again on cloud.

 

But I'm not sure about the root cause. At least this issue has been resolved :). 

 

Thanks!

v-easonf-msft
Community Support
Community Support

Hi ,  @Anonymous 

If you have make sure that all data source credentials are correct, please recheck the statue of your  data gateway.

Take a try to install the latest version of On-premises Data Gateway 

 

You may refer to this document to collect  more information from gateway logs and event logs.

 (look in Event Logs > Applications and Services Logs > On-premises data gateway Service )

 

Best Regards,
Community Support Team _ Eason

 

Anonymous
Not applicable

@v-easonf-msft , 

 

I already have the latest version. And there is no special in the event log. But the issue is still there. 

 

The tricky thing is I have several previous data source using same credential is working well. But when I want to create the new one , it has the issue. all the file is from the same place , so it should not be the permission issue. 1.png

 

Thanks!

Jack

Hi, @Anonymous 

What type of data source?Are the gateway and data source in the same domain?

 

If your data source is tabular data, you may consider whether it is caused by some parameters of the table (such as table name,  table structure, etc.)

 

It is recommended to create a support ticket to investigate this issue.Once you create a support ticket and get any workaround, please kindly share it here for reference.
https://powerbi.microsoft.com/en-us/support/

 

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

@v-easonf-msft ,

 

The data source is excel table. And the data source and gateway are in same domain. 

I have check the previous configured data source. All are working well. But I might need to understand how I can input the windows username and password. I tried to replace the same username (I input in new data source) in the previous data source. it has the same error. 

 

So I need to know what I input in the past for the previous data source. But it's hided. How do I know the previous input username and password ?  I tried everything I can try in the past few days. <domain name>/username , username@domianname.com, <domain name>. <suffix>/username , <domain name>/<full name>. All failed.1.png

Hi , @Anonymous 

Sorry for security reasons it is difficult to see the hidden password .The credentials are encrypted securely. They use symmetric encryption so that they can't be decrypted in the cloud before they're stored in the cloud. The credentials are sent to the machine that runs the gateway, on-premises, where they're decrypted when the data sources are accessed.

 

If you didn't  not know what your windows username is, and you might not be a domain administrator. You can use the following command from your workstation to find out it for your account ( windows username format: <domain> \ <username > ).

Please note that "\", not "/"

whoami

53.png 

 

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

Hi, 

 

For more detail, please see below error message from gateway logs. The error is always saying 'The parameter is incorrect'. 

1.png

Anonymous
Not applicable

@v-easonf-msft ,

 

Any idea of how I can get the correct windows account for data source? 

Appreciate if anyone can help on this. I'm sufferred a lot by this issue for weeks.

Thanks!

Jack

Hi , @Anonymous 

Please re-confirm your window username format (  domain \ username  ) and  your password  (usually the  password used to boot the computer).
In addition ,you may  check  if  the personal gateway is feasible.

 

You'd better create a support ticket in Power BI Support to get further help.
https://powerbi.microsoft.com/en-us/support/

Support Ticket.gif

 

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

@v-easonf-msft ,

 

I collected the error message in log file. Not sure if there is any clue for this issue. 

 

Starting trace on 6/8/2020 5:10:59 AM UTC
Version: 3000.40.15
UserDomainName: NT SERVICE
UserName: PBIEgwService
MachineName: PCDC-PRINTERSRV


DM.EnterpriseGateway Error: 0 : 2020-06-08T05:11:18.0594709Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 25E31978 [DM.Analytics] Performance counters not installed, application performance metrics will not be traced (category = Microsoft Power BI Enterprise Gateway)
DM.EnterpriseGateway Error: 0 : 2020-06-08T06:04:40.5550985Z DM.EnterpriseGateway 2b57a6a7-32d8-49d6-99bf-91f96298bab6 0da5a872-6417-b64d-0ad8-f15ba0e3a604 MGEC ee9860ac-19d8-4e3f-81a8-67d3921a8577 2a804282-31d4-46c8-bd18-682ec82f0892 2a804282-31d4-46c8-bd18-682ec82f0892 4B80A52E [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: System.Security.Cryptography.CryptographicException: The parameter is incorrect.

at System.Security.Cryptography.NCryptNative.DecryptData[T](SafeNCryptKeyHandle key, Byte[] data, T& paddingInfo, AsymmetricPaddingMode paddingMode, NCryptDecryptor`1 decryptor)
at System.Security.Cryptography.NCryptNative.DecryptDataOaep(SafeNCryptKeyHandle key, Byte[] data, String hashAlgorithm)
at System.Security.Cryptography.RSACng.Decrypt(Byte[] data, RSAEncryptionPadding padding)
at Microsoft.PowerBI.DataMovement.CommonUtilities.Security.AsymmetricHigherKeyEncryptionHelper.Decrypt(String cipherText, String containerName)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.EncryptCredentialsWithSymmetricKey(GatewaySerializationContext responseContext, Func`1 getPlainCredentials)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass6_0.<<EncryptCredentialsWithTestDataSourceConnection>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
DM.EnterpriseGateway Error: 0 : 2020-06-08T06:04:40.5571009Z DM.EnterpriseGateway 2b57a6a7-32d8-49d6-99bf-91f96298bab6 0da5a872-6417-b64d-0ad8-f15ba0e3a604 MGEC ee9860ac-19d8-4e3f-81a8-67d3921a8577 2a804282-31d4-46c8-bd18-682ec82f0892 2a804282-31d4-46c8-bd18-682ec82f0892 CF3D81B4 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=326, err=CryptographicException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2020-06-08T06:04:40.5581027Z DM.EnterpriseGateway cb16ad39-e30d-4c42-a515-88d5c8b700a6 0da5a872-6417-b64d-0ad8-f15ba0e3a604 MGPP ee9860ac-19d8-4e3f-81a8-67d3921a8577 2a804282-31d4-46c8-bd18-682ec82f0892 2a804282-31d4-46c8-bd18-682ec82f0892 31A8EEA4 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: System.Security.Cryptography.CryptographicException: The parameter is incorrect.

at System.Security.Cryptography.NCryptNative.DecryptData[T](SafeNCryptKeyHandle key, Byte[] data, T& paddingInfo, AsymmetricPaddingMode paddingMode, NCryptDecryptor`1 decryptor)
at System.Security.Cryptography.NCryptNative.DecryptDataOaep(SafeNCryptKeyHandle key, Byte[] data, String hashAlgorithm)
at System.Security.Cryptography.RSACng.Decrypt(Byte[] data, RSAEncryptionPadding padding)
at Microsoft.PowerBI.DataMovement.CommonUtilities.Security.AsymmetricHigherKeyEncryptionHelper.Decrypt(String cipherText, String containerName)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.EncryptCredentialsWithSymmetricKey(GatewaySerializationContext responseContext, Func`1 getPlainCredentials)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass6_0.<<EncryptCredentialsWithTestDataSourceConnection>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<EncryptCredentialsWithTestDataSourceConnection>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchImpl>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<Dispatch>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<DeserializeImpl>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass9_0.<<Deserialize>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
DM.EnterpriseGateway Error: 0 : 2020-06-08T06:04:40.5581027Z DM.EnterpriseGateway cb16ad39-e30d-4c42-a515-88d5c8b700a6 0da5a872-6417-b64d-0ad8-f15ba0e3a604 MGPP ee9860ac-19d8-4e3f-81a8-67d3921a8577 2a804282-31d4-46c8-bd18-682ec82f0892 2a804282-31d4-46c8-bd18-682ec82f0892 E5337F3F [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=338, err=CryptographicException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2020-06-08T06:04:40.5640815Z DM.EnterpriseGateway b026a6ba-e211-44a4-877c-e7fa4487c590 0da5a872-6417-b64d-0ad8-f15ba0e3a604 MDSR ee9860ac-19d8-4e3f-81a8-67d3921a8577 2a804282-31d4-46c8-bd18-682ec82f0892 2a804282-31d4-46c8-bd18-682ec82f0892 3D17D074 [DM.GatewayCore] Error processing request: System.Security.Cryptography.CryptographicException: The parameter is incorrect.

at System.Security.Cryptography.NCryptNative.DecryptData[T](SafeNCryptKeyHandle key, Byte[] data, T& paddingInfo, AsymmetricPaddingMode paddingMode, NCryptDecryptor`1 decryptor)
at System.Security.Cryptography.NCryptNative.DecryptDataOaep(SafeNCryptKeyHandle key, Byte[] data, String hashAlgorithm)
at System.Security.Cryptography.RSACng.Decrypt(Byte[] data, RSAEncryptionPadding padding)
at Microsoft.PowerBI.DataMovement.CommonUtilities.Security.AsymmetricHigherKeyEncryptionHelper.Decrypt(String cipherText, String containerName)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.EncryptCredentialsWithSymmetricKey(GatewaySerializationContext responseContext, Func`1 getPlainCredentials)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass6_0.<<EncryptCredentialsWithTestDataSourceConnection>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<EncryptCredentialsWithTestDataSourceConnection>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchImpl>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<Dispatch>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<DeserializeImpl>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass9_0.<<Deserialize>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<Deserialize>d__9.MoveNext()
DM.EnterpriseGateway Error: 0 : 2020-06-08T06:04:40.5671121Z DM.EnterpriseGateway b026a6ba-e211-44a4-877c-e7fa4487c590 0da5a872-6417-b64d-0ad8-f15ba0e3a604 MDSR ee9860ac-19d8-4e3f-81a8-67d3921a8577 2a804282-31d4-46c8-bd18-682ec82f0892 2a804282-31d4-46c8-bd18-682ec82f0892 8B1615CF [DM.Pipeline.Common] EnsureGatewayPipelineException encountered a non-GatewayPipelineException: System.Security.Cryptography.CryptographicException: The parameter is incorrect.

Anonymous
Not applicable

@v-easonf-msft , I already tried this. But unfortunately, it doesn't work. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors