Expression Error for SAP HANA Data Source: The key did not match any rows in the table

[MStP]

Hello,

I've seen this issue posted before but not for an SAP HANA data source. I get the following error ONLY when trying to refresh the dataset on the web service. There are no issues with connecting in the .pbix file or during initial publication. The data source is connected and returning data.

There are other HANA views in the dataset that do not cause issues. I have tried deleting the data source referenced below and recreating it from scratch and I still get the same issue.

Is this something that needs to be corrected on the HANA side? I'm not sure where to start here. 

Thanks,

Michael

[MStP · Accepted solution]

This message appeared because the specific HANA view was not made accessible for our Power BI HANA Service account. Not sure what this means but the issue is being resolved.

Michael

[MStP]

To be clear, this is an issue that needs to be addressed in HANA by enabling the view to be accessible by PBI: