dataformat.error

  1. Q

    Power Query: DataFormat.Error: We couldn't convert to Number.

    Good morning all, I'm at my wit's end! With no detectable changes to the datasource, suddenly I am getting an error on one of my queries. Here's the overview of what happens: The first import runs as a connection only. No errors are shown. It is an aggregation of 8 files that are pulled...
    • Qwest336
    • Thread
    • dataformat.error date power query query type
    • Replies: 3
    • Forum: Power Tools
  2. L

    DataFormat.Error

    I am trying to clean up data in Power that will eventually be exported into access (achieved employee records). Of the 2866 rows I imported into power query, I have 375 errors in one column and the error reads: DataFormat.Error: We couldn't convert to Time. Details: 1.083333333 *numbers under...
    • lynzlou
    • Thread
    • convert dataformat.error details errors power
    • Replies: 1
    • Forum: Power Tools

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top