Forum Discussion
Solved
Conversion format as number
Dear all, My data source is SQL, and I have a column that contains only numbers (no empty data nor letter, etc). The format is not automatically recognized as numbers. I would like to transform the ...
Hi Lili123 ,
- Yes, changing data type is not avilable in Power Query Editor for Direct Query mode.
- You could successfully change it in Column Tools tab, but please notice the risk dialog:
2. Or switch the mode to Import mode instead.
- Or if you have a sql source, you may make this transformation directly on the data source.
- In addition, here is a workaround by using NativeQuery that you could have a try:
For more information, please kindly refer to:
Using DirectQuery in Power BI - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Assuming you are using Table.TransformColumnTypes, try:
Table.TransformColumns(PriorStepOrTableName, {{"NumberColumnName", Number.From, type number}})
You might have to use each Number.From
--Nate
Hi Watkinnc,
I put this in the querry, sorry, but I still have the same error message. Thank you anyway.
Do you have another idea ?
