Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ZineBakh
Frequent Visitor

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?

2 ACCEPTED SOLUTIONS
ZineBakh
Frequent Visitor

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

View solution in original post

ZineBakh
Frequent Visitor

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

 

View solution in original post

14 REPLIES 14
ZineBakh
Frequent Visitor

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.

jjgb
Microsoft Employee
Microsoft 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.

jjgb
Microsoft Employee
Microsoft Employee

There was a bug in the July 2022 release of Power BI Desktop / Gateway that produced null values when adding a column that used the Cube.AttributeMemberId function.

 

This issue has been fixed in Power BI Desktop August 2022 version 2.108.997.0.

lebi87
New Member

You need to be using PBI Desktop and Gatway version that is not from JULY 2022. Otherwise you will have problems in Desktop and Service. I've just downgraded to JUNE 2022 version of Gateway and it solved the issue.

Update on the understanding on this issue so far:

Caused by the HANA View being setup with an "alternative column" in the 'Label Column' entry. It looks like this functionality exists to support Parameters shwoing a "alternative column name" like an aid when selecting a Parameter input. There is no way for user to see this design setup. Your org can screen all the views that have entries in this 'Label Column', and maybe decide to clear them (pending understanding why they are used in the first place).

 

Preventive action: HANA designers should never use 'Label Column' functionality in a Consumption View, only in Re-useable views where the Parameter comes from. Using in Consumption view will disrupt column for user, showing values of referenced Label Column instead of actual column when pulled through PowerQuery. 

 

See the screenshot of the design: HANA Label Column error.png

 

The PowerBI SAP HANA Connector BY DESIGN pulls the Key instead of the Text. So somehow, the View is desinged in such a way to result in this issue. My Organization has listed this to Microsoft as a Ticket / Bug. Issue does not apear in Tableau or in Hana Studio. They pointed me, as the initiator, to this workaround. 

Result for user: Hana Error with Key instead of text.png

 

Example of a Parameter input with an  2nd information column (‘description column’): 

HANA Parameter Description column.png

Anonymous
Not applicable

Any updates on this ? I get the same trouble with BW. But our prefrence is to use Direct Query which makes impossible to get to Power Query..

ZineBakh
Frequent Visitor

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
Frequent Visitor

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
Frequent Visitor

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.

FP
Frequent Visitor

Hi,

thank you very much for your answer.

Because of the post of below, dated 14 october, I tought it was a note problem (and hoped there was a solution).

I will try to find another solution... crossed fingers

ZineBakh
Frequent Visitor

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

 

FP
Frequent Visitor

Currently, as workaround I'm using the online version : we use the desktop to develop and after we copy on the online (users use the online), so I'm moving the activity on the ID values on the online.

In th enext days we will define our strategy 🙂

Thank you again

 

Hi! I followed these steps but I'm getting a null response for each record... how should I fix this?

Captura2.PNG

Captura.PNG

Anonymous
Not applicable

Hi! I followed these steps but I'm getting a null response for each record... how should I fix this?

Captura2.PNG

Captura.PNG

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors