Forum Discussion

setis's avatar
setis
Icon for Post Partisan rankPost 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
setis's avatar
setis
Icon for Post Partisan rankPost 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
Icon for Microsoft Employee rankMicrosoft 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