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.
Hi everbody
i have a problem and i hope that you could support me.
I create a new streaming Dataset( REST API):
Solved! Go to Solution.
Hi Bastian,
The format should be like the demo. So it should be like below taking your data as an example.
[ { "id" :"AAAAA555555", "cycle_value" :98.6, "timestampe" :"2018-07-27T10:21:44.883Z", "current" :98.6, "speed" :98.6 }, { "id" :"AAAAA555555", "cycle_value" :98.6, "timestampe" :"2018-07-27T10:21:44.883Z", "current" :98.6, "speed" :98.6 } ]
[ { "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current1(7)_Subscription_1000%Current-%#", "id": "rd_25", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", }, { "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current2(7)_Subscription_1000%Current-%#", "id": "rd_26", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", }, { "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current3(7)_Subscription_1000%Current-%#", "id": "rd_27", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", }, { "current":"#%-ItemValue%TB6.PLC_1.Inputs.Current4(7)_Subscription_1000%Current-%#", "id": "rd_28", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", } ]
Best Regards,
Dale
Hi Bastian,
The format should be like the demo. So it should be like below taking your data as an example.
[ { "id" :"AAAAA555555", "cycle_value" :98.6, "timestampe" :"2018-07-27T10:21:44.883Z", "current" :98.6, "speed" :98.6 }, { "id" :"AAAAA555555", "cycle_value" :98.6, "timestampe" :"2018-07-27T10:21:44.883Z", "current" :98.6, "speed" :98.6 } ]
[ { "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current1(7)_Subscription_1000%Current-%#", "id": "rd_25", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", }, { "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current2(7)_Subscription_1000%Current-%#", "id": "rd_26", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", }, { "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current3(7)_Subscription_1000%Current-%#", "id": "rd_27", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", }, { "current":"#%-ItemValue%TB6.PLC_1.Inputs.Current4(7)_Subscription_1000%Current-%#", "id": "rd_28", "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#", "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#", "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#", } ]
Best Regards,
Dale
Hi Dale,
it works. Thank you.
Best regards
bastian
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.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |