Forum Discussion

dpenny's avatar
dpenny
Helper II
9 years ago

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. S...
Need Help
dpenny's avatar
dpenny
Helper II
9 years ago

Sure, my unsuccessful next, and MS sample successful for comparison.

not workingworks

dpenny's avatar
dpenny
Helper II
9 years ago

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?

  • dpenny's avatar
    dpenny
    Helper II
    9 years ago

    I still cannot get my csv to load into BI. The error message is:

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Those MS error messages aren't very helpful!  That's a thorough analysis and I can't see any problems either, though I've been importing to Power BI Desktop rather than directly to Power BI Service - you have more control over the import process in the Desktop it seems.

       

      Can you test an import to Power BI Desktop?  Or upload a (safe) sample of your data here to test?

      • dpenny's avatar
        dpenny
        Helper II
        9 years ago

        Thanks for your conversation.

         

        But, err, umm how do I put/load my csv data file here?  There is no icon/method for attaching a file to this message.  And pasting the text in misses the whole point.

         

        I personally think it is file corruption, but I've checked the HEX chars out as best I can and don't see any.

         

        I also copied my data into the MS sample workbook, then save the new sheet as a csv. Same prob when I upload it.

         

        Hmmmmm.....