Direct query SAP HANA variables and date format

Hi,

sorry for german screenshots but I think "transform data" and "Daten transformieren" is similiar as "Date" and "Datum", both are wrong pronounced latin. 😉

first variables are variables from the SAP calculation view like date, business year or planning version.

They will be asked when connection to the database the first time, but should be changeable after creating the report.

Variables when connection to the calculation view

After the connection is established the PowerBI Desktop behaves different depending on "Treat SAP HANA as relational database".

If the flag is set I can change the format of a date column from text to date:

But I'm not able to change the variables from the first connection any more, as this menu entry is greyed out.

Without this flag the PowerBI Desktop I can not change the format of a column and a date column is text. (On HANA side it's formated as date and also the semantic information is set)

Change format is greyed out

But I can change the variables like date or planning version 

So there is always a killer for using PowerBI with a SAP BW HANA calculation view, which would be great as this is such a great tool for handling data.

Kind regards 

Matthias