Report does not load data when connected to SAP Hana directly

[suganya_r]

Hi,

I have a power bi report which is connected to SAP Hana directly to get its data. I connect in 'Direct Query' mode and do not import/load data. Since I use relational model to get data from more than one Hana Views I have enabled the settings options under File->Options & Settngs->Options-> Direct Query->Treat data as relational source. 

With all the above settings everything works fine in Power bi Desktop.

When I load the report to power bi on-prem web server, data does not get loaded to report. If I uncheck the settings 'Treat data as relational source' and create a report with single hana views, the report works fine on webserver.

Has anyone come across this issue? How do I fix it?

Thanks

Suganya