Data imported from odbc not fully visible in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2201852%22%20slang%3D%22en-US%22%3EData%20imported%20from%20odbc%20not%20fully%20visible%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2201852%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20unable%20to%20get%20all%20data%20in%20excel%2C%20using%20get%20data%20through%20ODBC.%20Data%20i%20want%20to%20fetch%20is%20visible%20in%20query%2C%20but%20its%20not%20reflecting%20in%20excel%20sheet%20after%20i%20close%20and%20load%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2201852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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

@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

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!