Forum Discussion

Regular Visitor

4 years ago

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

Need Help

Anonymous
4 years ago
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.

Anonymous

Not applicable

4 years ago

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.