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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
edemirel
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

5 REPLIES 5
k_e
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

v-yuta-msft
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 "(".

1.PNG2.PNG 

 

Regards,

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.

Anonymous
Not applicable

Hi guys,

 

Is there any sotution?

 

Thanks a lot.

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.