Forum Discussion

amalrio's avatar
amalrio
Helper V
5 years ago
Solved

SAP HANA Relational View

Hi, 

 

I have activated relational source from PowerBI options as below and connected to SAP HANA. but when I connect to SAP HANA I see all the views as cube. is it the default view?. I expcet them to view as tables similar to SQL DB. This is the first time I am using SAP HANA. Any help would be appriciated. (please refere the images below).

 

 

 

 

 

Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi amalrio ,

     

    I think the navigation page is more similar to the Analysis Services data source in import mode, and you cannot change it to a table icon similar to SQL Server. But connect SAP HANA as a relational source, you can create relationships between the generated tables.

     

    For more about SAP HANA relational source, please refer to:  Treat SAP HANA as a relational source 

     

     

    Best Regards,
    Winniz

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

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    5 years ago

    Hi amalrio ,

     

    I think the navigation page is more similar to the Analysis Services data source in import mode, and you cannot change it to a table icon similar to SQL Server. But connect SAP HANA as a relational source, you can create relationships between the generated tables.

     

    For more about SAP HANA relational source, please refer to:  Treat SAP HANA as a relational source 

     

     

    Best Regards,
    Winniz

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