// 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
Share

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

  1. FIX 1Find the bad values

    1. 01In Power Query select the column
    2. 02Use Keep Rows > Keep Errors to see failing rows
    3. 03Note the offending text
    Did this fix it?
  2. FIX 2Clean the values

    1. 01Right-click the column > Replace Values to remove %, currency symbols or spaces
    2. 02Or Replace Errors with null if the values are not needed
    Did this fix it?
  3. FIX 3Fix the Changed Type step

    1. 01Select the automatic Changed Type step
    2. 02Change the column type after cleaning steps, not before
    Did this fix it?
  4. FIX 4Use locale-aware typing

    1. 01Right-click the column header > Change Type > Using Locale
    2. 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 us

Watch Microsoft Power BI Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

The same problem in other apps

All not loading, error messages & connection guides →

Other Microsoft Power BI errors

All 14 Microsoft Power BI errors and fixes →