Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Decimal to Text

Hello everybody,   I am trying to load an Excel-Sheet into Dataverse, with a variety of Datatypes, via Dataflow. But i want to load all off them as plain text. All transformational steps should be ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 😞