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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nhoff
Advocate I
Advocate I

Personal gateway - InvalidCredentialFormat - Signature does not match

I have a dataset which uses the personal gateway to publish data. I have used it succesfully for more than 3 months.

 

Last succesfull data refresh was 29/3. When I tried to refresh the data 2/4 it says in the error message that the gateway is not online. Even though it is.

 

gw1.JPGgw2.JPG

 

I have tried to uninstall and reinstall the data gaway (march 2018 version).

 

The gateway logs report an error, that I don't know what to do with (see below).

 

Any suggestions would be appreciated.

 

****

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_SignatureNotMatchCredentialError --->
Inner exception chain: System.FormatException
<pi>System.FormatException: InvalidCredentialFormat - Signature does not match
ved Microsoft.PowerBI.DataMovement.CommonUtilities.SymmetricKeyEncryptionHelper.Decrypt(SymmetricKeyEncryptedResultDataContract encryptedData, SymmetricKeyContractBase key)
ved Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.CredentialUtils.DecryptSymmetricKey(SymmetricKeyEncryptedResultDataContract encryptedData, SymmetricKeyContractBase key)</pi>
--- End of inner exception stack trace ---
([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.InvalidCredentialDueToSignatureNotMatchException.StackTrace:)
ved Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.CredentialUtils.DecryptSymmetricKey(SymmetricKeyEncryptedResultDataContract encryptedData, SymmetricKeyContractBase key)
ved Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.CredentialUtils.DecryptCredential(CredentialDetails credentialDetails, IGatewayCredentialStore credentialStore)
ved Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.DbConnectionProviderBase.DecryptCredential(CredentialDetails credentialDetails)
ved Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.MashupConnectionProviderBase.PrePrepareMashupCredential(DataSourceGatewayDetails datasource, String dataSourceKind)
ved Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.MashupOleDbConnectionProvider.<PrepareMashupCredential>d__5.MoveNext()

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@nhoff,

What is your data source? Currently, you will experience refresh failures getting a personal gateway error if you refresh cloud data source using web.page() function. You can check the notification in Power BI support site.

1.PNG

Regards,
Lydia

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

Hi Lydia

 

Thanks for responding. I am using a mix of:

 

a) on-premise SQL server,

b) xlxs and txt files on local sharepoint,

c) xlxs files on O365 OneDrive

 

I am not sure which of these qualifies as a cloud data source', but I guess the latter could be.

@nhoff

Are you able to use on-premises gateway rather than personal gateway to refresh the dataset? You can follow the guide in the blog below to add data sources within gateway.

https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-february-update-is-now-available/

Regards,
Lydia

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors