Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.