Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data formatting - Numbers are identified as text

Hello everyone! I'm kinda new to PBI and stumbled across a problem that I have no idea how to solve. In query editor I have a table with column formats set to match the data types. Column "Сумма" f...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Created a new file and CopyPasted the full query to the new file.

    Everything works fine.

     

    The only difference is that I did not create any measures and did not create any calculation tables in Tabular Editor.

    Could it possibly be one of the reasons for a glitch? 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Created a new file and CopyPasted the full query to the new file.

Everything works fine.

 

The only difference is that I did not create any measures and did not create any calculation tables in Tabular Editor.

Could it possibly be one of the reasons for a glitch? 

negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous there are three places where you can change the data type (you can't change text to number if text has non-numeric characters)

1. source : Define the data type in the source data if possible

2. power query: change the data type here if you can't change it in the source

3. Power Bi desktop: finally, if it is not possible to change the data type in above two cases then change here. There are few data type which are only supported in the power bi desktop