Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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
Hello Tiege, do you know howe to do this? Sorry, very new to these software.
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.