Forum Discussion
streaming dataset - manipulate values
Hi together,
i have a question i hope you can anwer me that.
So i receive values via modbus-protocol on a middleware and i foward them directly in power bi.
Works great!
But there's a little thing that bothers me...
I read temperature values out of the registry from a device, the format is 356 that means 35,6°C.
I realy want to convert the data, is there a possibilty to manipulate that in powerbi / streamind dataset?
Best regards
bastian
Hi Bastian,
There could be several methods.
1. I would suggest you modify it before pushing to Power BI.
2. Method 2 is as below.
2.1 Enable the "Historic data analysis" of the streaming dataset in Power BI Service.
2.2 Connect to the dataset in the Service from Desktop. (the Power BI connector)
2.3 Create a measure.
Measure = min('RealTimeData'[current])/102.4 Publish the report to Service.
2.5 Pin the visual to Dashboard.
Best Regards,
Dale
2 Replies
Hi Bastian,
There could be several methods.
1. I would suggest you modify it before pushing to Power BI.
2. Method 2 is as below.
2.1 Enable the "Historic data analysis" of the streaming dataset in Power BI Service.
2.2 Connect to the dataset in the Service from Desktop. (the Power BI connector)
2.3 Create a measure.
Measure = min('RealTimeData'[current])/102.4 Publish the report to Service.
2.5 Pin the visual to Dashboard.
Best Regards,
Dale
Hi Dale,
thanks for your support.
I tried thesecond method but I´m not happy with this.
So, I#m convinced that I should solve the problem at the source.
Best regards
Bastian
