Data imported from odbc not fully visible in excel

[sid123]

i am unable to get all data in excel, using get data through ODBC. Data i want to fetch is visible in query, but its not reflecting in excel sheet after i close and load data.

[#2]

@sid123 

And if you change in Power Query last 3 columns on Decimal or Whole Number data type?

[#3]

thanks a lot its now working with whole number option.

[#4]

@sid123 , thanks for the update, glad it helped

[#5]

Thank you so much, @Sergei Baklan! I created an account to sign in so I could reply to this thread and thank you for your wonderful reply.

Thank you, too, @sid123, for posting this question!