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.
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.
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êsRegards
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êsHi @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.
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êsThank you for your help! That was the piece I was missing 
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
