Forum Discussion

ZineBakh's avatar
ZineBakh
Frequent Visitor
7 years ago
Solved

Getting Key instead of text from SAP HANA (New issue with Power bi July 2022)

Hello team, please be informed that there were a new issue with the latest PBI version. it turned the Cube.AttribID in PowerQuery to Blank. Anyone is facing the same?
Need Help
  • ZineBakh's avatar
    ZineBakh
    7 years ago

    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]).

ZineBakh's avatar
ZineBakh
Frequent Visitor
7 years ago

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]).

FP's avatar
FP
Frequent Visitor
4 years ago

Hi, I have the same issue and I tryied with your solution, but sadly - as the other reply below - I received only "null" insead of the key values.

Should we do something else to make the solution work properly ?

  • ZineBakh's avatar
    ZineBakh
    Frequent Visitor
    4 years ago

    Hi - this is a new issue happened with the new July version, not sure if Microsoft are aware about it. but I heard a lot of people having the same issue. the old cube.attribute.ID PowerQuery formula does not function anymore. not sure if this formula got retired and there is another new one or it is just a bug.