Forum Discussion
Decimal to Text
Hi Anonymous ,
Power BI has a data type automatic detection function, it will automatically detect the data type of the data when you import the data. You can turn it off in the options.
If you only want to change the data type to text format, you can modify it in Power Query or in Desktop.
Tips: Power Query detects at most the eighth decimal place. You can refer to the following test.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank You for Your replay,
I had the auto detection allready turned off. In Power Query everything looks fine (in Datatype "Any") But when I run the Dataflow, the decimal places appear in the table out of nowhere.
When I Change the Datatype to "Text", the decimal places appear allready in the Query.
It is drving me nuts, I dont want it to do any transformation, just keep plain text without altering itHi Anonymous ,
Because the data flow is managed in Power BI Service, the automatic detection you turn off is only in Power BI Desktop. You may need to modify the data type.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It is PowerApps Dataflow, so the option for Auto detect should be applicable. I am not working with Power BI in any kind. (Maybe another Subforum would have been more suiteable)
Seems to be the same Problem here.
Power-Query-Power-BI-Problem-with-Decimals
=>Cant change anything in the Source-Excel
=>Need to import as Text/String
=>Cant Round a String
=>Need to convert on a second Dataflow to Number
Wouldn't have thought this to be so exotic 😞