添加参考数据输入时将流分析输出到Power Bi的问题 [英] Problems to get stream analytics output to Power Bi when adding a reference data input

问题描述

您好，

我开发了一个流分析作业，使用IoTHub作为输入，Azure SQL和Power BI作为输出。

I have developed a stream analytics job using IoTHub as input and Azure SQL and Power BI as outputs.

然后我添加了一个非常简单的表作为Azure SQL的参考数据。

Then I have added a very simple table as reference data from Azure SQL.

我已经扩展了查询以将此表连接到iothub流输入。所有连接测试工作正常。在Visual Studio和Azure门户中使用示例数据进行测试时，查询工作正常。

I have expanded the query to join this table to iothub stream input. All the connection test work fine. The query works fine when tested in Visual Studio and in Azure Portal with sample data.

但是当作业运行时我没有输出。

But I get no ouput when the job is runnig.

在Visual Studio中本地运行查询，使用cloud inpunt和ouput，我收到以下错误：

Running the query locally in Visual Studio, using cloud inpunt and ouput, I get the following error:

"错误：无法转换输出'outputDeviceArea'：Data Lake Sotre Gen1和Poer Bi稍后将作为授权问题予以支持。"

"Error: Failed to convert output 'outputDeviceArea' : Data Lake Sotre Gen1 and Poer Bi will be supported later as authorization issue.."

现在我正在使用Data V2帐户和Data Lake Gen2文件系统，错误仍然存​​在。

Now I am using a Storage V2 account with Data Lake Gen2 file systems and the error persists.

任何想法？

如果在使用AzureSQL参考数据输入时无法使用PowerBi输出，我怎么能得到一个实时面板如果我需要加入iot消息中未包含的数据（作为设备所在的区域）？

If I cannot use PowerBi output when using an AzureSQL reference data input, how could I get a real time panel If I need to join data not included in the iot message (as the area where the device is located)?

谢谢，

推荐答案

您好AurelioGL，

Hi AurelioGL,

Stream Analytics也支持输入称为 参考数据。参考数据要么完全静止，要么变化缓慢。它通常用于执行关联和查找。例如，您可以将数据流输入中的数据连接到
中的数据参考数据，就像执行SQL连接以查找静态值一样。

Stream Analytics also supports input known as reference data. Reference data is either completely static or changes slowly. It is typically used to perform correlation and lookups. For example, you might join data in the data stream input to data in the reference data, much as you would perform a SQL join to look up static values.

注意： Azure Blob存储是目前唯一受支持的参考数据输入源。参考数据源blob的大小限制最多为300 MB，具体取决于查询复杂性和分配的流媒体单元。

Note: Azure Blob storage is currently the only supported input source for reference data. Reference data source blobs have a limit of up to 300 MB in size, depending on the query complexity and allocated Streaming Units.

有关参考数据输入的详细信息，请参阅  使用Stream Analytics中的查找参考数据

For more information about reference data inputs, see Using reference data for lookups in Stream Analytics

Azure Stream Analytics目前不支持写入ADLS Gen2，但我们正在努力。

Azure Stream Analytics does not currently support writing to ADLS Gen2, but we are working on it.

同时，我建议您投票给另一个Azure提交的想法客户。

Meanwhile, I would suggest you to vote up an idea submitted by another Azure customer.

https://feedback.azure.com/forums/270577-stream-analytics/suggestions/36857047-output-to-adls-gen-2

所有您在这些论坛中分享的反馈将由负责构建Azure的Microsoft工程团队进行监控和审核。

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

这篇关于添加参考数据输入时将流分析输出到Power Bi的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！