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
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.....

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Apologies - it seems only some parts of the site (or Administrators) are allowed attachments.  If you can load the sample to OneDrive, Google Drive, DropBox etc. you could link here.  Even so, copy-pasting some sample lines of CSV in via the 'Insert Code' to a Reply would help determine if it's the file content or the file itself causing you grief.

     

    Have you tried copy-pasting the content to a new file and re-importing?

    • dpenny's avatar
      dpenny
      Helper II
      9 years ago

      Again, thanks for answering.

       

      Yes, I tried copyNpaste rectangular region from my csv workbook sheet into the MS sample csv workbook. Then saved as xlslx (mispell??), then re-opened and saved my new sheet as csv with a new name. This too fails as Power NI upload.

       

      Some lines from my csv copied from a high-end text editor program next

      =====start (but not this line)

      AUDIT,Region,Tot,InProgress,ActionPlan,FollowUp-A,FollowUp-B,Closed
      Chile,LAT,13,0,0,13,0,0
      Australia Sales,APC,28,0,6,6,0,16
      Brazil,LAT,19,0,0,0,0,19
      Lockbox,US,15,0,0,0,0,15
      China Dev,APC,33,0,0,33,0,0
      Colombia,LAT,8,0,8,0,0,0
      Consulting,US,9,0,0,0,0,9
      Commissions,US,10,0,0,0,0,10
      Consulting Svcs,US,27,11,16,0,0,0
      China Sales,APC,11,0,11,0,0,0
      Commissions-New,US,17,0,0,0,17,0
      OutSource IT General Control,APC,10,1,0,0,0,9

      =====end

       

      HTH

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        And of course, when I copy-paste that sample text into a CSV (via Excel), it works just fine for me in PBI Desktop and PBI Service...

         

        Sadly, without the file itself, I can't help further.  If you have a Pro licence, you can of course lodge a support ticket with Microsoft via https://powerbi.microsoft.com/en-us/support/