Power BI中的Log Analytics数据 [英] Log Analytics data in Power BI

问题描述

我正在尝试使用Data Factory V2  AzureDiagnotics登录Log Analytics以通过管道和活动获得性能。 列output_executiondetails_s为json（我认为）。 在Power BI中，我可以将其转换为JSON，然后列为
LIST，单击它返回Record，单击它返回6行（源，接收器，状态，开始，持续时间，usedparallelcopies和详细信息）。  ; 

I am trying to use the Data Factory V2  AzureDiagnotics logs in Log Analytics to get performance by pipeline and activities.  The column output_executiondetails_s as json (I think).  In Power BI, I can tranform it to JSON then the column is LIST, clicking on it returns Record , clicking on it returns 6 rows (source, sink, status, start, duration, usedparallelcopies, and detaileddurations).  

如何解析此数据以在Power BI中使用它？ 

How can parse this data out to use it in Power BI? 

任何建议都有帮助。 

Any suggestions are helpful . 

推荐答案

我没有你提到的数据所以我无法测试并告诉你确切地说，Log Analytics使用的Kusto语言非常强大。例如，有一个运算符parse_json（）

I do not have the data you are mentioning so I cannot test and show you exactly but the Kusto language which Log Analytics uses is very powerful. For example there is a operator parse_json()

https://docs.microsoft.com/en-us/azure/kusto/query/parsejsonfunction

https://docs.microsoft.com/en-us/azure/kusto/query/parsejsonfunction

它接受包含json的字符串列并可以将其转换为动态。

That takes string column that contains json and can convert it to dynamic.

之后，您可以使用extend根据动态值创建新列。

After that you can use extend to create new columns based on the dynamic value.

如果有帮助，请将此回复标记为答案。

mark this reply as answer if it was helpful.

这篇关于Power BI中的Log Analytics数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！