Forum Discussion

bastian_mpnkt's avatar
bastian_mpnkt
New Member
8 years ago
Solved

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 t...
Need Help
Show and Tell
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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. 

    streaming_dataset_manipulate_values

    2.2 Connect to the dataset in the Service from Desktop. (the Power BI connector)

    2.3 Create a measure.

    Measure = min('RealTimeData'[current])/10

    2.4 Publish the report to Service.

    2.5 Pin the visual to Dashboard.

    streaming_dataset_manipulate_values2

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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. 

streaming_dataset_manipulate_values

2.2 Connect to the dataset in the Service from Desktop. (the Power BI connector)

2.3 Create a measure.

Measure = min('RealTimeData'[current])/10

2.4 Publish the report to Service.

2.5 Pin the visual to Dashboard.

streaming_dataset_manipulate_values2

 

Best Regards,

Dale

bastian_mpnkt's avatar
bastian_mpnkt
New Member
8 years ago

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