Error: 'The value is not a cube', While connecting the SAP HANA data to Power BI using Direct Query

[rudra_deep]

While trying to connect SAP HANA data source to Power BI using Direct Query mode, It gives an error stating "The value is not a cube", upon clicking on load (PS: the query shows the data to load/edit however upon clicking on any one of it, it throws the mentioned error). Any assistance would be greatly appreciated. 

[v-cherch-msft · Accepted solution]

@rudra_deep

You may try to update your desktop to latest version and go to the options->DirectQuery to select the option Treat SAP HAHA as a relational source. Here is the document for you.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-hana

Regards,

Cherie

[Anonymous]

Hi I am facing the same issue but this dosenot resolve the issue. Can you help on this?

[rudra_deep]

Thank you so much for your kind assistance @v-cherch-msft. I am able to connect now.