topic Power Query isn't recognizing numbers in Power Query

Power Query isn't recognizing numbers

danyac1591 — Fri, 22 May 2020 02:09:04 GMT

Hello everyone,

I've uploaded a database to PowerQuery, but it's not recognizing some numbers. The problem appears in only one column of some files. I've checked every file and the column the program doesn't recognize is formated as number just like the other columns. I don't know what's happening here.

Does anybody knows how to solve this? Thanks

Re: Power Query isn't recognizing numbers

v-juanli-msft — Mon, 25 May 2020 05:15:54 GMT

Hi danyac1591

It is appreciated of you to paste some filtered data from data source here so i can use your data to reproduce this problem.

Please let me know what steps you have made in "applied setps" pane, do you change any data type for any column?

Best Regards

Maggie

Re: Power Query isn't recognizing numbers

danyac1591 — Thu, 04 Jun 2020 17:53:46 GMT

Hi v-juanli-msft ,

Thanks for replying.

Here's the data and the PBI file: https://dencmi-my.sharepoint.com/:f:/p/dacuna/EmDwOBxc7U1Mr0zc9lXW_UoB_prKgikI8bIBka2x0iGSpg?e=jrhRt2

Re: Power Query isn't recognizing numbers

danyac1591 — Mon, 15 Jun 2020 17:25:54 GMT

So no one can help me with this? 😭