The key didn't match any rows in the table - It won't refresh from Data Gateway

[BrianHo168]

Hi,

I am new to the Data Gateway connection trying to schedule refresh for my dataset.  I configured the data gateway and data sources successfully.  However, I am getting "The key didn't match any rows in the table" error from refresh.  The refresh ran fine within Power BI desktop.  It just won't refresh from the data gateway. 

When I tried again, this time it errors on the sql view of vw_InventoryByStore which I have given permission to the data source user.

Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259 Table: vw_InventoryByStore.
Underlying error message: The key didn't match any rows in the table.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Key: [Schema = "dbo", Item = "vw_InventoryByStore"]
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-US-WEST2-redirect.analysis.windows.net
Activity ID: 39909f1e-d7aa-4be3-a93f-132ce8f6a8de
Request ID: cc77e8b6-9c47-01be-53d2-551830de82ac
Time: 2019-03-16 01:02:20Z

Any recommendation?

[Anonymous]

Hi Brian,

I face the same issue now.

May by you've managed to find any solution already?

Thanks