Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Direct query SAP HANA variables and date format

Hello experts,   I would like to use PowerBI Desktop as a frontend for SAP BW HANA. Looks fine on the first glance, but there are some obstacles. If I use direct query without "Treat HANA as relat...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dear v-angzheng-msft,

 

where the screenshots helpful? 

Can I add any information to resolve this problem?

 

Kind regards

Matthias 

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

Sorry for the late reply, I actually wasn't able to reproduce your question due to the fact that I don't have that data source to test.

I checked a lot of information and found a piece of information that might be helpful.

 

To enable the SAP edit variables feature, in Power BI Desktop connect to an SAP HANA or SAP BW data source. Then go to File > Options and settings > Options and then, in the Current File section in the left pane, select DirectQuery. When you select that, in the right pane you see DirectQuery options, and a checkbox where you can Allow end users to change SAP variables in the report, as shown in the following image.

 

Refer:

To enable the SAP edit variables feature.

Connect to SAP HANA databases in Power BI

 

Hope this helps

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.