Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Improper format for numeric fields in Power query

Hello,   I am using SAP BW as a data source in my Power BI reports. When i am importing data in Power BI desktop via Power Query Editor, few of the values in a numeric field seem to be imported in ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Instead of converting to a type, try inserting the line below the Source. It might turn the data into a number. You can then proceed with setting the rest of your types.

 

= Table.TransformColumns(Source,{{"MTD_Balance_LC2", each Number.From(Text.Replace(Text.From(_),"*","")), type number}})

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Thanks for getting back. But my issue is not actually to replace the _,* in the data. In the source , there is valid data for this. Like for the value _*556217.0700000000 , the source has a value 15556217.07. So in reality, when I import the data in Power BI, I am losing data and getting this weird data format.