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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
wesfletcher
Frequent Visitor

Excel Data Load

Hi,

 

I'm trying to load ledger data into Power BI through excel. I'm having an issue when I load an account with a "-" in it.

 

Does anyone have any ideas on what is causing this issue? I've included sample data below.

 

Capture.JPG

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @wesfletcher,

 

When you do the upload of a table from excel or any type of file the first 200 rows are used to define the type of field that the column as so if the first row is only number it will give that row a number type format when it tries to convert the rest of the column when it encounters a "-" it gives and error.

 

You can solve this by just choosing the second step "Changed Types" and formatting the account column to text and your issue should be solved.

 

formatting.png

 

Regards,

MFelix

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

 

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



MFelix
Super User
Super User

Hi @wesfletcher,

 

When you do the upload of a table from excel or any type of file the first 200 rows are used to define the type of field that the column as so if the first row is only number it will give that row a number type format when it tries to convert the rest of the column when it encounters a "-" it gives and error.

 

You can solve this by just choosing the second step "Changed Types" and formatting the account column to text and your issue should be solved.

 

formatting.png

 

Regards,

MFelix

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you for your help! That was the piece I was missing Smiley Very Happy

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.