使用Stream分析为IoT Hub中的每个设备创建Power Bi数据集 [英] Use Stream analytics to create a Power Bi Dataset for each device in my IoT Hub

问题描述

我正在寻找有关设置流式分析的一些帮助。 我目前有一个Stream分析工作，它从我的IoT Hub获取数据，并用它创建一个Power Bi数据集。 这适用于一个设备，但是，我将
需要连接到我的IoT集线器的多个设备，每个设备都需要为每个设备创建一个Sperate Power Bi数据集，以便我为每个设备创建一个仪表板。  我一直与Azure帮助聊天联系，但是，他们建议
在这里询问，因为他们无法回答我的所有问题。 是否可以使用单个Stream Analytics作业为我的IoT中心中的每个设备创建数据集？ 由于这个项目可能需要大量的设备，因此需要尽可能轻松地扩展
。尽可能降低成本。

Hi, I'm looking for some help regarding setting up my Stream Analytics.  I currently have a Stream analytics job which gets the data from my IoT Hub and creates a single Power Bi Dataset with it.  This works fine for one device, however, I will require multiple devices connected to my IoT hub, which will each need to have a sperate Power Bi dataset created for each in order for me to create a Dashboard for each device.  I have been in contact with the Azure Help Chat, however, they suggested asking here as they could not answer all of my questions.  Is it possible to use a single Stream Analytics job, to create a dataset for each of the devices in my IoT hub?  Due to this project potentially needing a large number of devices, it will need to be easily scalable with as little cost implications as possible.

希望有人可以告诉我这是否可能，并指出我正确的方向。

Hopefully, someone can let me know if this is possible and point me in the right direction.

谢谢，

Gregor

Thanks,
Gregor

推荐答案

您好Gregor，

Hi Gregor,

设计Stream Analytics查询时，请使用  INTO子句查看输出的名称。如果需要，可以在查询中提供多个INTO子句，则可以为每个作业使用单个输出，或者为每个流作业使用多个
输出。

When you design your Stream Analytics query, refer to the name of the output using the INTO clause. You can use a single output per job, or multiple outputs per streaming job if you need by providing multiple INTO clauses in the query.

有关详细信息，请参阅"了解Azure流分析的输出"。

For more details, refer "Understand outputs from Azure Stream Analytics".

此外，您可以参考
SO 主题，解决类似问题。

And also, you may refer SO thread, which addressing similar issue.

希望这会有所帮助。

这篇关于使用Stream分析为IoT Hub中的每个设备创建Power Bi数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！