Data imported from odbc not fully visible in excel

Question

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.

sergeibaklan · Answer

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

sid123 · Answer

thanks a lot its now working with whole number option.

sergeibaklan · Answer

sid123&nbsp;, thanks for the update, glad it helped

cover-stealing_badger · Answer

Thank you so much,&nbsp;SergeiBaklan! I created an account to sign in so I could reply to this thread and thank you for your wonderful reply.&nbsp;Thank you, too,&nbsp;sid123, for posting this question!&nbsp;

Forum Discussion

Data imported from odbc not fully visible in excel

4 Replies

Resources