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
    Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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.