Forum Discussion

JTRRTriad's avatar
JTRRTriad
New Member
4 years ago

Issues importing csv file into workspace

I tried importing a .csv file into my workspace and it came up with an error. Can someone please advise?

 

 

Activity ID: 9956ddf1-98c4-44c2-bac2-ac391860ebb2
Request ID: 95e2f69c-c23c-04c1-6f00-e8d30adb5248
Correlation ID: 5d834475-3ff4-8cdc-e1e5-39978dade8b2
Status code: 400
Time: Thu May 05 2022 12:58:08 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.18173.56
Client version: 2204.4.11089-train
Cluster URI: https://wabi-us-east-a-primary-redirect.analysis.windows.net/

3 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support

    Hi JTRRTriad,

     

    Did you try it again? or you can try use excel to save as excel to upload it again.

     

    Best Regards

    Community Support Team _ chenwu zhu

  • So I did, but had reformated the headers in the file and set the table. Then saved as a workbook and it somehow was able to work. Not entirely sure why as another .csv file worked.

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support

      Hi JTRRTriad,

       

      There are some ways like save as by excel to handle non-standardized .csv files. You can refer to Wikipedia for a description.

      Comma-separated values - Wikipedia

       

      Best Regards

      Community Support Team _ chenwu zhu

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.