Forum Discussion
Solved
Power Query - Mixed numbers and letters error - help
Hi, Please help me on this issue. I've changed the Stock Code column to text then used custom columns to created separate columns like text and numbers using below formulas then applied and gett...
It seems there's something in your code that's making Power Query try to change the data type of your [Stock Code] column to a number.
Can you copy the whole query code from Advanced Editor and paste it into a code window ( </> button) here please?
Feel free to anonymise the connections strings etc.
Pete
It seems there's something in your code that's making Power Query try to change the data type of your [Stock Code] column to a number.
Can you copy the whole query code from Advanced Editor and paste it into a code window ( </> button) here please?
Feel free to anonymise the connections strings etc.
Pete
Hi BA_Pete,
Thanks you for your help. I have sorted the problem.
I have created file from starting then it's working.
Kind regards,
PV