Forum Discussion

setis's avatar
setis
Post Partisan
7 years ago

Importing table from excel

Hi!   I've noticed that when importing a table (table formatted) from excel, the numbers are imported as text. Even when changing the data format in the query editor to number, they are managed as ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi setis,

Based on my test, it could work on my side, could you have formatted the number to text in excel?

 

Regards,

Daniel He

  • setis's avatar
    setis
    Post Partisan
    7 years ago

    Hi v-danhe-msft, Thanks for reaching out. It's weird but it is not. It's formatted as number. 

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi setis,

      Could you please share your excel file and your pbix file to have a test if possible?

       

      Regards,

      Daniel He