Forum Discussion
Unable to create multiple tables with streaming Dataset
Hello, I am working on an IoT project and want to show sensors real time data on Power BI dashboard. I am unable to do this because In streaming Dataset Power BI does not create multiple tables against multiple sensors rather that it sums the data of all sensors in a single table. Therefore, request you all to please give an idea to resolve this issue.
Any set of solution would be welcomed.
Regards,
Amit Singh
HI Amit221,
>> I am unable to do this because In streaming Dataset Power BI does not create multiple tables against multiple sensors rather that it sums the data of all sensors in a single table.
Yes, one streaming dataset api is match with one table, current it not allow you do custom on streaming dataset records.
In my opinion, I'd like to suggest you to create multiple streaming api to handling different sensors data, you only need to push your data to different api.
Other way is add columns store different sensors data and push them at same time.(for eg. fields: timestamps, sensor 1, sensor 2,...) Then use timestamps with different sensor fields to create different visuals.Regards,
XIaoxin Sheng
2 Replies
HI Amit221,
>> I am unable to do this because In streaming Dataset Power BI does not create multiple tables against multiple sensors rather that it sums the data of all sensors in a single table.
Yes, one streaming dataset api is match with one table, current it not allow you do custom on streaming dataset records.
In my opinion, I'd like to suggest you to create multiple streaming api to handling different sensors data, you only need to push your data to different api.
Other way is add columns store different sensors data and push them at same time.(for eg. fields: timestamps, sensor 1, sensor 2,...) Then use timestamps with different sensor fields to create different visuals.Regards,
XIaoxin Sheng
Anonymous: Thanks for your support.. I have created multiple Dataset as of now and its working fine. However, i did't get your second point would you please brief that process.
