Direct Query - SAP HANA Database

[bselby]

Good afternoon,

I have a question about the Direct Query mode of the SAP HANA Database connection.

Creating and using the connection in the first instance works perfectly - I can connect to Calculation Views stored on our HANA databases, design dashboards and publish them.

My issue is that once that initial connection is made, it cannot be changed or edited. This is a massive burden when trying to replicate the same dashboard across multiple databases, because the layout has to be built from scratch again in a new dashboard with a new connection.

As an example, we have a sales dashboard looking at a Calc. View for our Australian database. We'd like the same dashboard for our New Zealand database. I'd expect to be able to create a copy of the dashboard file and change the connection to look at the New Zealand Calc. View, especially because all the fields are the same. Unfortunately, I can't find a way to do this.

Does anybody have a solution? Data Source Settings only allows me to change the connection credentials.

[v-yuezhe-msft · Accepted solution]

@bselby,

Please go to File > Options and settings ->Options > DirectQuery, then select the option "Treat SAP HANA as a relational source". After you create Power BI report with this option, you can make a copy of PBIX file and change connection to views.

Regards,
Lydia

[bselby]

Thank you for your help Lydia, I wasn't aware of that setting.