Data imported from odbc not fully visible in excel

New Contributor

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.

3 Replies

@sid123 

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

thanks a lot its now working with whole number option.

@sid123 , thanks for the update, glad it helped