Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Cannot update DATASET

I am trying o use 3 DATASETS which are being streamed from IoT Hub in Azure through Stream Analytics. The data section is numerical, say 0.134 etc. I am then attempting to create a bar graph, but the option to use data does not appear in the drop down menu for data.  When I view the values from stream I see that the Data is set to TEXT, when I try to set this to number it comes up with an error. One of my datasets is working fine but I cannot change the other 2 and I need to add more, Help please !

Super User
Super User

Can you remove the field from the stream and add it again?

Super User
Super User

You need to modify the field definitions for your dataset. Something like this:




Hi Ibendlin,

   Yes I need to modify one field definition as you say above called 'data' but this is the issue. Everytime I attempt to it calls up an error,



and the error looks like this 


Now I managed to change this on one Data Stream but I am unable to change on the others ?

What actually sets the value code (TEXT,NUMBER,DATECODE) as if it was already set to NUMBER I would have no issues





Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors