Showing results for 
Search instead for 
Did you mean: 
New Member

Displaying Keys from SAP HANA on Import Mode

Trying to display specific Keys (IDs) instead of the descriptions of the said attributes. Is there a specific way to retrieve Keys with a function or a query change when using HANA Calculation Views in Import Mode? Below are two screenshots that show the difference between PowerBI and BOBJ Analysis.


BOBJ vs PowerBI

Frequent Visitor

Hello there,

Isn't there any solution yet, I am facing the same issue. The key & text are available when connected using direct query & no longer available when the connection is switched to import mode

Community Support
Community Support

Hi edemirel,


Based on your description, you are using import mode to connect to HANA, right? And you want to achieve specific values in your text every row, right? You can click Query Editor-> Transform-> Split Column using Custom mode by "Total" and "(".




Jimmy Tao


Hey @v-yuta-msft, thanks for the response.


Not exactly. I blocked those values in the screenshots as they were confidential info. 


What I'm trying to do is how to make the data in Material: ABC Stratification PowerBI look like the data from BOBJ Analysis.

Not applicable

Hi guys,


Is there any sotution?


Thanks a lot.

Frequent Visitor

No solution for this point ... I have same issue

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.