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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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