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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dpenny
Helper II
Helper II

uploading giving funny results again?

I went through a period of 1-2 wks where I could not upload a csv produced by Excel 2013. It always errored out. I fixed it by opening the file with a text editor and resaving, then uploading this version.  Oh well........

 

Today I am trying to upload a different csv produced by Excel 2013, it went into BI, but there is an extra column in BI that is not in my csv file. It's heading is "_Column" without the quotes.

 

All I did to produce this file is save a particular sheet (no formulas at all) as type csv.

 

What happened?

Where did this come from?
How do I prevent it?

 

 

12 REPLIES 12
v-yuezhe-msft
Employee
Employee

Hi @dpenny,

Do you connect to the CSV file from Power BI Service or Power BI Desktop?

I am not able to reproduce your scenario when connecting to CSV file in Power BI Desktop or Service. Would you please share me your CSV file with which I can test and post a screenshot about your current scenario?


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I gave up on using the Service with csv files unless I run the csv files from Excel through a true "editor" like TexPad or Note++ and re-save to a txt file, then manually change the extension to csv.

 

What a pain. You'd think sticking within the MS stack that things would work well.

Hi @dpenny,

How about connecting to CSV files from Power BI Desktop? We will appreciate that if you can share us your CSV file so that I can test.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1) sure I can send/share my csv file, but how, there is no "attached button/icon" in this forum blog that I see.

 

1) i insert  next a screen snip of what happens

2) how do I attach a csv file? there is no icon/button

3) this is from BI DeskTop

 

load_err_2.jpg

Hi @dpenny

In your scenario, please select Column8 in Query Editor of Power BI Desktop, then click “Remove Columns” under Home ribbon as shown in the following  screenshot to remove the column8.
1.PNG

And in Query Editor of Power BI Desktop , you can select the first row in  your table, then click “Use First Row As Headers” under Transform ribbon, this way, you will get original column title.
2.PNG

In addition, you can upload the CSV file to OneDrive and post shared link of it in this forum.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I found out the hard way to use query editor to "fix" the csv.

 

The real point is that BI should not have interpretted the csv file this way. This is a bug or a design flaw.

And why after I run it through a real text editor, and then upload to BI does it work just fine????

 

With respect to putting my csv onto OneDive, I dont have an account, and I should not have to get one just to share files to help debug BI.

 

If I sound angry and annoyed, I am. I expect MS products to work seamlessly with each other (maybe not with other companies products).

 


@dpenny wrote:

I found out the hard way to use query editor to "fix" the csv.

 

 

 


Hi @dpenny,

What is the problem when you use query editor to remove column and change column heading? Would you mind sharing me the CSV file with dummy data so that I can test it?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I can't re-produce the situation. I will try again.

 

I think I may have deleted the cvs file. I started running all my data through a "text editor" before uploading to BI desketop or BI service.

Hi @dpenny,

Is your issue resolved after performing the above steps? The issue you get doesn't happen to all CSV files. In my sceanario, Power BI Desktop connects to CSV as expected.

Sometimes, due to incorrect data format in CSV, Power BI Desktop cannot recognize the column headings. In this scenairo, we can use features in Query Editor to solve it.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

what does

incorrect data format in CSV

mean?

 

Your suggestion is likely true, BUT,

  1. Excel does not have any probs with this file
  2. text editors (TexPad, Note++, etc.) don't have any probs with this file.

 

Since BI is Miscrsoft's next BIG thingy, you'd think it would be smarter than all prior products, no?

 

And furthermore, if it is incorrect data format in CSV you'd also think that BI could tell you something like

at line xyz, unrecognized char (in hex), etc etc.

 

 

Baskar
Resident Rockstar
Resident Rockstar

cool,

 

U r saying the latest changes are not shown right ?

 

May i know where u looking for the latest change in Report or Dashboard ?

 

if in Dashboard, dashboard won;t give u the latest file data untill the data resfresh .

Report, not dashboard.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors