// troubleshooting guide · microsoft power bi
Power BI DataFormat.Error: We Couldn't Convert to Number
- Status
- Workaround available
- platforms:
- Power BI Desktop, Power BI service
- updated:
- November 16, 2026
- reports:
- 3
- Method
- how we research
RUNBOOK · power-bi/dataformat-error-convert-to-number4 FIXES
// quick answer
Power Query hit a value it can't turn into a number, usually a symbol like %, a stray character, or a decimal separator from another locale. Find the bad value, clean it with Replace Values or fix the Changed Type step.
Most likely fix: Find the bad values
How to fix it
// try these in order, the most common fix is first
FIX 1Find the bad values
- 01In Power Query select the column
- 02Use Keep Rows > Keep Errors to see failing rows
- 03Note the offending text
Did this fix it?FIX 2Clean the values
- 01Right-click the column > Replace Values to remove %, currency symbols or spaces
- 02Or Replace Errors with null if the values are not needed
Did this fix it?FIX 3Fix the Changed Type step
- 01Select the automatic Changed Type step
- 02Change the column type after cleaning steps, not before
Did this fix it?FIX 4Use locale-aware typing
- 01Right-click the column header > Change Type > Using Locale
- 02Pick Decimal Number and the source locale
Did this fix it?
SANDBOX · power-bi RUNS IN YOUR BROWSER
Try it: browse a sample shop and watch visitors, funnels and live data arrive
A hands-on Microsoft Power BI-style sandbox, including the spots where users get stuck. See where problems like this one start. 1-2 minutes, nothing is saved.
Symptoms
Refresh or Apply changes fails with 'DataFormat.Error: We couldn't convert to Number', or cells show Error in Power Query.
Why it happens
- C-01Text like %, currency symbols or N/A in a numeric column
- C-02Decimal and thousands separators from a different locale
- C-03An automatic Changed Type step set the column to number too early
// this guide also covers
- dataformat.error we couldn't convert to number
- power bi couldn't convert to number
- power query dataformat error
Still not working?
If Microsoft Power BI keeps failing, you're not alone. See every Microsoft Power BI problem users report or the alternatives people switch to.
Done fighting Microsoft Power BI? Our small team builds your own Microsoft Power BI alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to usThe same problem in other apps
All not loading, error messages & connection guides →
Tableau "Unable to Start Due to an Internal Licensing Error" (Tableau)
Looker Studio GA4 Quota Exceeded Error (Looker Studio)
Metabase Dashboard Slow or Not Loading (Metabase)
Superset Dashboard Slow or Charts Timing Out (Apache Superset)
Other Microsoft Power BI errors
- Power BI Scheduled Refresh Failed
- Power BI Gateway Offline or Could Not Be Reached
- Why Is My Power BI Report So Slow?
- Power BI Desktop Refresh and Power Query So Slow
- Power BI Desktop Not Opening or Stuck on Splash Screen
- Can't Sign In to Power BI Desktop
- Power BI Visual Has Exceeded the Available Resources
- Power BI Error: The Key Didn't Match Any Rows in the Table