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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.