Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Currency notation missing from excel source

Hi Experts,   In my excel datasource, when the currency column is like 5 EUR, it is getting imported in Power BI as 5, meaning that all the currency notation is not getting displayed in PBI for tha...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    To my knowledge you will not be able to import the data with the varied currency data format. I belive that you will need to add an additional column in the excel source data that holds the currency. 

    Br,
    J

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    I think this is default behaviour. 

    You will need to create a column with the country name and then use this formula.

     

    Regards,

    Harsh Nathani

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

I think you have gone to the next level. But my quesion is different. Sorry if I didn't explain it well. Let me repeat now.

 

In my excel the values are like below for column 'PRICE'. 

 
tex628's avatar
tex628
Community Champion
6 years ago

To my knowledge you will not be able to import the data with the varied currency data format. I belive that you will need to add an additional column in the excel source data that holds the currency. 

Br,
J