Conversion format as number

[Lili123]

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 column as number, but I have the message (sorry it's a translation of the original message, I might not be the right one) : 

"this step generates a query that is not supported in directquery mode "

 Can somebody help me to transform the data, please ?

Thanks a lot.

Regards

[v-eqin-msft · Accepted solution]

Hi @Lili123 ,

• Yes, changing data type is not avilable in Power Query Editor for Direct Query mode.

1. 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.

[Lili123]

Thank you for your very well documented answer. It works properly!

[watkinnc]

Assuming you are using Table.TransformColumnTypes, try:

Table.TransformColumns(PriorStepOrTableName, {{"NumberColumnName", Number.From, type number}})

You might have to use each Number.From

--Nate

[Lili123]

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 ?