The key didn't match any rows in the table error in Power BI Service with SAPBW as Datasource

[kundanqlikview]

Hi community,

I am facing with error in Power BI Service while refreshing the report manullay or even during the auto schedule refresh  as "The key didn't match any rows in the table" . The dataset refresh works fine when I do it in PowerBI Desktop.

My Source is SAP BW which is taking the start and end date and value type as parameters

We have checked with gateway is up and running smoothly and other reports with same SAP BW Server are running without any issues. we have even checked by clearing the cache from report and at the desktop level and also checked wtih privacy level. everything llok fine. but still we are facing issue in power bi service while refresh happens, and at desktop level we are good in refreshing with the report without any issues/errors.

Any ideas where I could look for an error and resolve the issue?

Thanks in advance.

Thanks

Srinivas