Text file import error - missing rows

[erajan007300]

my dashboard data sources are predominantly text files. Tab delimited, text files. I import into power bi desktop - ~8k rows. I import into an excel spreadsheet - ~19k rows. The 19k is accurate. I've read about power bi imports treating all text files as if they had a csv format? I thought I read this was addressed in a previous update? I first downloaded power bi about 2 weeks ago. There has to be a solution to this? Excel imports without error but power bi doesn't?

Any help would be greatly appreciated

[Seth_C_Bauer]

I would also recommend getting the latest desktop update here

[Greg_Deckler]

Any chance that you data is not sensitive and you could post it? This issue will be very difficult to troubleshoot otherwise.

[erajan007300]

X1_XD	X2_XD	X3_V_CXDY	X4_V_GXXY	X2_CXDY	X2_GXXY	X6_CXDY	X7_GXXY	X7_CXDY	X8_X_GRXUX	X9_X_G_DYSC	X10_CXT	X11_C_DYSC	X12_SUXC	X13_SUXC_DYSC	X14_T	X12_TYXY_XD	X16	X17_XSX	X18_XSX_G	X19	X20_G	X21	X22_F_DXS	X23_XLXT	X24_XGY_R	X22_V_CX	X26_XR	X27_XD_TYXY	X28_XD	X29_GUX	X30_SKU	DT_X31_CRY	DT_X32_CRY	DT_X33_LXU	DT_X34	DT_X32	DT_X36	DT_X37	DT_X38_UTC	DT_X39	RYLYXSY_X40_LYVYL	XS_X41_DXSX	XS_X42_SUXX	XS_X43	XS_X44	HXS_X42	X46_THYXY_XD	X47_DYSCRXXTXXG	X48_CXUGT	X49_CXUGT	X20_RXTXGG
1	7	SYGX7	SYgX Xf XXYrXcX - XC gXXYs	SYGX7	SYgX Xf XXYrXcX - XC gXXYs	SYGXR	SYgX	XX	63	gl_vXdYX_gXXYs	6302800	2800 XlXystXtXXG 3 GXXYs XGd SXftwXrY	6302832	2832 SXXrts & XutdXXrs	CXGSXLY_VXDYX_GXXYS	3222	sXXrts_XGd_XutdXXrs_gXXYs	X008FWZWXG	LXGdXG 2012 XlyXXXcs - XlXystXtXXG 3	X0074ZXXZS	LXGdXG 2012 XlyXXXcs Xs3 - StXGdXrd YdXtXXG	StXGdXrd	XlXyStXtXXG 3	XlXystXtXXG 3	YvYryXGY	24	29.99	UXC	010086690620	010086690620		03/06/2012	08/21/2012	03/02/2012	06/26/2012		06/26/2012	06/26/2012	06/26/2012		hXgh	Y		G	G	G			1	1	2
1	7			XXWY9	XXdwXy			XX	63	gl_vXdYX_gXXYs	6302200	2200 XthYr XlXtfXrX GXXYs XGd SXftwXrY	6302202	2202 SYgX GXXY GYXr	CXGSXLY_VXDYX_GXXYS	3222	XrcXdY GXXYs	X00004R9FY	XXXYrXXy	X00004R9FY	XXXYrXXy				kXds_tX_Xdults		0	UXC	031763029618			07/02/2004	08/21/2012	06/22/2002	06/22/2002			06/22/2002	06/22/2002			Y		G	G	G				0	0
1	7			XCTX9	XctXvXsXXG	XCTH2	XCTXVXSXXG XGC.	XX	63	gl_vXdYX_gXXYs	6301900	1900 XXXx GXXYs XGd SXftwXrY	6301910	1910 ClXssXc GXXYs & RYtrXXrcXdY	XXXS_VXDYX_GXXYS	363	XctXXG GXXYs	X0008FU160	WXrld SYrXYs Xf XXkYr - XXXx	X0008FU160	WXrld SYrXYs Xf XXkYr - XXXx			XXXx	YvYryXGY_10_Xlus		22.99	UXC	047872720999			02/27/2002	08/21/2012	06/11/2007	06/11/2007		08/23/2002	08/23/2002	08/23/2002			Y		G	G	G			1	0	0
1	7			TXXX2	TXXXX				63	gl_vXdYX_gXXYs	UGKGXWG	UGKGXWG	UGKGXWG	UGKGXWG	CXGSXLY_VXDYX_GXXYS	3222	XdvYGturY-gXXYs	X0037XSTUW	TXXXX FlXrXst ShXX	X0037XSTUW	TXXXX FlXrXst ShXX			GXGtYGdX DS	YvYryXGY	16	0	UXC	692771802242	DS-2012		07/12/2010	08/21/2012	03/12/2013	03/12/2013			03/12/2013	03/12/2013		hXgh	Y		G	G	G			2	0	0

Here's a sample - I replaced a number of characters with "X".  I did not change any spacing or puncuation.  Hopefully this is enough to give some insight on the issue I'm having.  If not, please lmk what would be desirable.  Thank you.

[curth]

Can you please "send a frown", attaching this (mangled) sample to the email it generates?

[erajan007300]

I figured the data would help.  However, it is sensitive.  I can try to provide a sample.  I thought I had the most recent update - the version number reads 2.26.4128.403.