实施IoT PowerBI表架构 [英] Implementing IoT PowerBI table schema

问题描述

我目前正在实施一个物联网解决方案，该解决方案具有大量传感器通过网关以JSON格式发送信息.

I'm currently implementing an IoT solution that has a bunch of sensors sending information in JSON format through a gateway.

我正在阅读有关在azure上执行此操作的信息，但无法完全弄清楚JSON方案和事件中心如何在PowerBI上显示信息?

I was reading about doing this on azure but couldn't quite figure out how the JSON scheme and the Event Hubs work to display the info on PowerBI?

我可以创建一个架构并将其上传到PowerBI，然后将其连接到我的设备吗?

Can I create a schema and upload it to PowerBI then connect it to my device?

推荐答案

这有很多方面.首先，如您所提到的，通过事件中心完成Azure中的IoT摄取.如果您的网关能够对事件中心入口点进行RESTful调用，则事件中心将获取此数据并在指定的保留期内临时存储.然后进行流分析，将使用来自事件中心的数据，并使您能够进行进一步处理并将数据转移到不同的输出.在您的情况下，您可以将输出之一设置为PowerBI仪表板，您可以使用组织帐户对其进行授权(稍后再进行介绍)，并且输出将自动绑定到PowerBI.数据模式部分很有趣，JSON本身定义了将在PowerBI端使用的数据表模式，并将通过发送的第一个JSON包从EventHubs传播到Stream Analytics到PowerBI.架构存在后，它便已修复，流式传输的其余数据应采用相同的格式.

there's multiple sides to this. To start with, the IoT ingestion in Azure is done tru Event Hubs as you've mentioned. If your gateway is able to do a RESTful call to the Event Hubs entry point, Event Hubs will get this data and store it temporarily for the retention period specified. Then stream analytics, will consume the data from Event Hubs and will enable you to do further processing and divert the data to different outputs. In your case, you can set one of the outputs to be a PowerBI dashboard which you can authorize with an organizational account (more on that later) and the output will automatically tied to PowerBI. The data schema part is interesting, the JSON itself defines the data table schema to be used on PowerBI side and will propagate from EventHubs to Stream Analytics to PowerBI with the first JSON package sent. Once the schema is there it is fixed and the rest of the data being streamed in should be in the same format.

如果您手边没有可用于PowerBI的组织帐户，则可以在Azure Active Directory中注册您的域并使用该帐户，因为在组织中考虑了该帐户.

If you don't have an organizational account at hand to use with PowerBI, you can register your domain under Azure Active Directory and use that account since it is considered within your org.

之后可能会有一种使用PowerBI rest api更改架构的方法.请在下面找到链接.我自己还没有尝试过.

There may be a way of altering the schema afterwards using PowerBI rest api. Kindly find the links below..Haven't tried it myself tho.

https://msdn.microsoft.com/en-us/library/mt203557.aspx

使用powerbi进行流分析

希望这会有所帮助，如果您需要更多信息，请告诉我.

Hope this helps, let me know if you need further info.

这篇关于实施IoT PowerBI表架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！