Forum Discussion
The connection string used for the mashup data source is invalid
Hi Anonymous,
This seems to be an error specific to your data source. I found this post where users are running into the same issue and how they fixed it: https://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-any-rows-in-the-table/td-p/9824
Thanks!
Dimah
dimazaid thank you. I have gone through most documentation related to this error but havent been able to solve it. In power BI desktop the report is refreshing just fine and I only get this issue in the web version. The only log file I found does not specify which data source this issue is related to so its difficult to troubleshoot. In the log file I got the following error:
GetAdmsGatewaySymmetricKeys failed with exception = System.IO.FileNotFoundException: Could not find file 'C:\Users\XXX\AppData\Local\Microsoft\On-premises data gateway (personal mode)\Bin\Configurations'.
File name: 'C:\Users\XXX\AppData\Local\Microsoft\On-premises data gateway (personal mode)\Bin\Configurations'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.File.InternalReadAllBytes(String path, Boolean checkHost)
at Microsoft.PowerBI.DataMovement.PersonalGatewayConfigurator.FileSerializer.ReadFile()
at Microsoft.PowerBI.DataMovement.PersonalGatewayConfigurator.FileSerializer.DeserializeToDynamicObject()
at Microsoft.PowerBI.DataMovement.PersonalGatewayConfigurator.MigrateDatasources.GetAdmsGatewaySymmetricKeys()
at Microsoft.PowerBI.DataMovement.PersonalGatewayConfigurator.MigrateDatasources.Migrate()
PersonalGatewayConfigurator.exe Information: 0 : GetAdmsGatewaySymmetricKeys found no keys. Still trying credential migration for datasources not needing decryption.
PersonalGatewayConfigurator.exe Warning: 0 : Failed to migrate DatasetID 31560349-b93d-4e84-8f52-1f8f2d9f47d4 in service
PersonalGatewayConfigurator.exe Warning: 0 : Failed to migrate DatasetID 31560349-b93d-4e84-8f52-1f8f2d9f47d4 in service