Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JTRRTriad
New Member

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 3
JTRRTriad
New Member

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.

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.

v-chenwuz-msft
Community Support
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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.