Any way to convert a text field to numeric field from realtime data?

[SimpoPower]

Hello, I have a data set created from a microsoft flow from microsoft forms to power BI (a 'realtime data set').  I am having issues with the flow so may have to set all data outputs as 'text' format, even if they are numbers.

Is there anyway to convert the text fields to number fields so I can utilise the numbers, such as averaging etc?  

Or if anyone knows how to fix the original flow issue, my original request at the link below:

https://community.powerbi.com/t5/Desktop/Flow-failing-between-Forms-and-Power-BI-Any-help-much/m-p/7...

[TeigeGao]

Hi @SimpoPower ,

For the realtime data, we can't edit the data type at the PowerBI Desktop end, why not change it directly in PowerBI Data flow? 

Best Regards,

Teige

[SimpoPower]

Hello Tiege, do you know howe to do this?  Sorry, very new to these software.

[Greg_Deckler]

You can convert it in either Power Query or Desktop. Right-click the column and switch it. May get errors/error if there is non-numeric text in the field though.