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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

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
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.