Not refreshing report using HANA database // General error 339 invalid number

[Anonymous]

I am not allowed to refresh a report because it says the following error:

[v-luwang-msft]

hI @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @smaniott ,

Added "isnull" check and empty check using if then else logic in Hana Database in calculated column.  

And refer the following article and check if is is helpful:

https://community.tableau.com/s/question/0D54T00000C5ijASAR/how-to-convert-a-string-to-an-integer-fr... 

https://support.boyum-it.com/hc/en-us/articles/360013557718-Mrp-calculation-on-HANA-enviroment-retri... 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[amitchandak]

@Anonymous , The data type is the number in the given table and column. But power bi is not getting the number. Go to change Type step and make it text and debug the reason

[Anonymous]

Thank you! But do you know where can I find the details of the column? I know what table is , but in the following error message, I can not find what column is the affected one:

General error;339 invalid number: attribute value is not a number;fixed(round([here]double(\"L48296.#_SYS_QO_COL_L:15755_713465819e90:402800000a5fe2ae.COL$47$\"), 0), 18, 0), L48296.#_SYS_QO_COL_L:15755_713465819e90:402800000a5fe2ae.COL$47$ = ''[string]: "}}