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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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