Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Cannot update Dataset

When attempting to change a streaming dataset value for DATA from text to number, I continiously get this error,

 

Activity ID: ae311547-d3da-41f0-bd14-70d98227ff60
Request ID: 2bd9d2ed-84e3-3c8f-3fa6-252fde10c653
Correlation ID: 08e933ba-3ddd-b4f1-0b66-b8c7a2ac6785
Status code: 409
Time: Thu Mar 18 2021 17:09:00 GMT+0000 (Greenwich Mean Time)
Service version: 13.0.15639.20
Client version: 2103.2.05290-train
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

 

Can someone help please

Status: New
Comments
v-lili6-msft
Community Support

hi

I have tested on my side, it works well.

if this value is a number type? please check it in datasource.

and if you could follow the steps below to re-created the streaming dataset see if it works well:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard

 

Regards,

Lin

Anonymous
Not applicable

Hi Lin,

Can you explain how to check if the value is a number type? as in checking it in the datasource.

 

The Data is a number say '0.234' and it comes from a particle.io integration to Azure IoT Hub and then to Stream Analysis to Power BI,

the JSON for the integration code looks like below,

 

DesOwens_0-1616143762766.png

If I run a report from the DATASET in Power BI I can see all the data and it is all correct. 

DesOwens_1-1616143865591.png

I just need to be able to change the Value for DATA above from TEXT to NUMBER, but it keepe throwing up an error as below. I have one DATASET working correctly but cannot change the rest,

DesOwens_2-1616143964802.png

Any Ideas?

 

Des