Forum Discussion
data not showing at all
I am a new BI user, but almost an Excel guru (or so I thought). I uploaded a csv file maybe 10 cols x 50 rows. I checked that all the two text cols are "text" and the #cols contain integer numbers. Since its csv, of couse, there are no tables.
When I choose 2 or 3 fields, nothing shows up in the window (dont know the correct name for the pane/pain).
To check myself, I then downloaded the MS sample financial data csv file, uploaded to BI, and tried to mess around. It worked just as I expected.
I deleted and re-uploaded my csv a second time - same result.
So what's keeping my csv data set from working? I've tried all integrity data checks I can think of. I'm using MS Excel 2013.
14 Replies
Sure, my unsuccessful next, and MS sample successful for comparison.
not workingworks
1) I just finished viewing my csv file and MS sample csv file in an edit prog where I can see ALL the chars in file. The two csv files look the same to me except that MS csv file had blanks around almost all the commas, mine had no blanks before/after each comma.
2) I tried uploading my csv file again. This time a yellow triangle (warn icon) appeared by my "data set name." The info associated was 4 (or5) guids. No real help.
3) I tried "insights" on both csv files. MS one showed a linear trend line. Mine gave msg "no insights available."
4) My file had two minus chars in header row, as dashes between words. I changed these to underscore, no difference.
So Q still remains, what is wrong with my csv file?
