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
Aron_Moore
Solution Specialist
Solution Specialist

HANA Currency

Hello everyone,

 

Anyone experience this?

 

While trying to bring in currency type (a string) from our HANA system I get nulls instead of the actual value.

Interestingly, the nulls don't collapse down into one row and the query doesn't return "empty" or "no rows matching".

I get "different" nulls equal to the rows that should contain currency types.

Other columns (even other strings) come through fine.

 

copa.jpgspl.png

 

text.PNG

 

Any thoughts?

1 REPLY 1
Aron_Moore
Solution Specialist
Solution Specialist

So data preview in HANA showed the type as a string, yet the field in the ADSO shows type CUKY.

Thinking this may be causing the issue I created a new field type CHAR 3 and mapped to the new field and it comes through.

Odd I can't use the original.

 

Guess I need to go create new fields in all my tables......

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.