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
v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Anonymous 

 

Could you please consider sharing some screenshots to illustrate your situation?

 

If I use direct query without "Treat HANA as relational database" all date fields are treated as text and the data type is greyed out. But I can change variables in the transformation menu

If I use direct query with "Treat HANA as relational database" I can change the data type of my date fields to date but in the transformation menu the entry "variables" is greyed out.

What does the entry "variables" in the transformation menu refer to?

 

 

  • 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
      Community 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.