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