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.

4 Replies


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

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!