In one end I am sending a single table to power bi from stream analytics using the query
一方面,我发送一个表来使用查询从流分析中获取bi
SELECT DeviceId, SignalCode, MeasurementTime INTO receivedsignalcodes FROM inputeventhub
And on the other hand I am uploading a table with some specific signal codes which indicate a fault into the power bi.
另一方面,我上传了一个表格,其中包含一些特定的信号代码,表明功率bi有故障。
Input from these two sources are becoming seperate datasets in powerbi. My question is if there is anyway to join these two tables and see which signals that I received in stream analytics are in excel fault codes table inside powerbi.
来自这两个来源的输入正在成为powerbi中的单独数据集。我的问题是,无论如何都要加入这两个表,看看我在流分析中收到的哪些信号是在powerbi内的excel故障代码表中。
I am open to any suggestions like writing a new stream analytics query but it gives error if i reuse the power bi output again in same query. Or I can upload my excel file to azure storage to reuse it that way but it seems like power bi does not support blob storage yet.
我对编写新的流分析查询等建议持开放态度,但如果我在同一查询中再次重用power bi输出,则会出错。或者我可以将我的excel文件上传到azure存储以便以这种方式重用它,但似乎power bi还不支持blob存储。
1 个解决方案
#1
We're looking at how to make it more flexible, but as you note today the data would go to separate data sets and you'd not be able to join directly across them in the web ui.
我们正在研究如何使其更加灵活,但正如您今天所指出的那样,数据将分散到单独的数据集中,您无法在Web ui中直接连接它们。
You can follow two solution paths: Optimize for analytics: You'd output the Stream Analytics output to Azure SQL. Then pull the data into Excel from there. You'll then be able to do the data mashup the way you'd like.
您可以遵循两个解决方案路径:优化分析:您将Stream Analytics输出输出到Azure SQL。然后从那里将数据拉入Excel。然后,您就可以按照自己喜欢的方式进行数据混搭。
Optimize for real time: Within stream analytics, join the data and ensure the output query includes all the reference data in the data set that is pushed into Power BI.
实时优化:在流分析中,加入数据并确保输出查询包括推入Power BI的数据集中的所有参考数据。
HTH, Lukasz
#1
We're looking at how to make it more flexible, but as you note today the data would go to separate data sets and you'd not be able to join directly across them in the web ui.
我们正在研究如何使其更加灵活,但正如您今天所指出的那样,数据将分散到单独的数据集中,您无法在Web ui中直接连接它们。
You can follow two solution paths: Optimize for analytics: You'd output the Stream Analytics output to Azure SQL. Then pull the data into Excel from there. You'll then be able to do the data mashup the way you'd like.
您可以遵循两个解决方案路径:优化分析:您将Stream Analytics输出输出到Azure SQL。然后从那里将数据拉入Excel。然后,您就可以按照自己喜欢的方式进行数据混搭。
Optimize for real time: Within stream analytics, join the data and ensure the output query includes all the reference data in the data set that is pushed into Power BI.
实时优化:在流分析中,加入数据并确保输出查询包括推入Power BI的数据集中的所有参考数据。
HTH, Lukasz