Forum Discussion
Power query help
Hi Anonymous ,
Your data should show correctly in Power BI data view.
Indeed, long numbers are not properly handled in Power Query, I had the same problem with UPC codes, which are basically a 12 digit number.
You have 2 options:
-one option is to format the column as Whole Number or decimal numbers, as needed, then from Transform tab, Text Column section, Format the column as lowercase (uppercase, propercase, trim or clean will also work). I know it does not make sense, but it works...
-The second option is to add a new column with a formula to format the original column to General format, using the G switch:
=Number.ToText(Number.From([Column]),"G"))
You can play around with different formats, instead of General, like "D", "N", "#", "000000000000"
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Your data should show correctly in Power BI data view.
Indeed, long numbers are not properly handled in Power Query, I had the same problem with UPC codes, which are basically a 12 digit number.
You have 2 options:
-one option is to format the column as Whole Number or decimal numbers, as needed, then from Transform tab, Text Column section, Format the column as lowercase (uppercase, propercase, trim or clean will also work). I know it does not make sense, but it works...
-The second option is to add a new column with a formula to format the original column to General format, using the G switch:
=Number.ToText(Number.From([Column]),"G"))
You can play around with different formats, instead of General, like "D", "N", "#", "000000000000"
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.