Forum Discussion
Power Query isn't recognizing numbers
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
3 Replies
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
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
So no one can help me with this? ğŸ˜
