Forum Discussion
Getting Key instead of text from SAP HANA (New issue with Power bi July 2022)
The existing functionality of the Power BI Connector for SAP HANA only exposes text values. To get the Key values after you have loaded the required columns from Hana, we need to be in the Query Editor, then go to Add Column Add Custom Column. Then double click on the column that we need to pull the Key values from. If the column name is Customer, then you will see = [Customer] in the Custom Column Formula box. After that’s done, replace it with the following: Cube.AttributeMemberId([Customer]).
For now, as a workaround, you can use the previous version of Power BI by downloading it from
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Docs
This issue is still current in Aug version, hopefully they will fix it in the next new version. as of now, I'm using PBI May version and it works fine for me.
jjgbMicrosoft Employee
The issue I mentioned was introduced in the July 2022 release and affects Calculation Views in HANA 2.0+ servers. Note that the original issue in this thread is really by design, if that's related to your case please refer to the other posts for alternatives.
If your scenario works in the May version but is now broken in the August version, I'd be interested to know more. For that I'd need to see:
1. The affected Mashup query (copied from the advanced editor)
2. Right click on the last step of the query in the May 2022 version, select View Native Query and share the query.
3. Right click on the last step of the exact same query in the August 2022 version (make sure it's version 2.108.997.0), select View Native Query and share the query.
4. Is it an analytical view or calculation view? What's the HANA server version?
If you don't feel comfortable sharing the information above here, it's probably best to open an incident through Microsoft support. Ideally, I'd ask for traces / query plan of the queries to investigate.