Error when trying to refresh dataset with a On Premise gateway

[Anonymous]

Hello, 

I keep getting the error below. I din't understand why it's showing this error now becuase this datasets has worked fine previously. 

I'm not doing transformations in Power Query simply importing the a SQL view.  

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Schema = \"dbo\", Item = \"vwBINominalTransactions\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: Query1.
Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID: 22499393-90c1-4e21-baea-c72aebdb9159
Request ID: 5096ee51-17ea-f247-cdc1-2e39381e30d8
Time: 2023-10-18 11:27:11Z

[Anonymous · Accepted solution]

Hi  @Anonymous ,

You can check that the service account running the gateway has read access to the data source and that the credentials for Power BI Service match the credentials on Power BI Desktop.

This is the related document, you can view this content:

Solved: Gateway - The key didn't match any rows in the tab... - Microsoft Fabric Community

Solved: The key didn't match any rows in the table error m... - Microsoft Fabric Community

Solved: Key Expression Error: The key didn't match any row... - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.