問(wèn)題描述

我已將 Azure 流分析作業(yè)輸出設(shè)置為 Power BI.但我在分析工作中收到警告，PBI 服務(wù)不支持的 System.Object 類型.

I have set Azure Stream Analytic job output as Power BI. But I am getting warning in the analytic job that System.Object type which is not supported by PBI service.

我也無(wú)法在 Power BI 中看到任何數(shù)據(jù).但我可以看到那里創(chuàng)建的數(shù)據(jù)庫(kù)確保流分析作業(yè)輸出正在那里.

Also I am not able to see any data in Power BI . But I can see the database created there which ensure that stream analytic job output is coming there.

以下是發(fā)送到 Power BI 的示例數(shù)據(jù).我知道發(fā)生錯(cuò)誤是因?yàn)槠渲幸粋€(gè)屬性是 object .我可以在 Power BI 做些什么來(lái)處理這個(gè)問(wèn)題?

Below is the sample data sent to Power BI. I know the error happens because one of the property is an object . Is there any thing I can do at Power BI to handle this?

{"test":
{"name":"testApp",
"date":"2015-07-31T10:38:45.1276956+05:30",
"flag":true,
"val":"2015-07-31T10:38:45.1276956+05:30",
"var":"123","231":1},
"cmd":"123",
"root":"123123",
"result":61116}

推薦答案

為了處理這種情況，我們需要修改流分析查詢.

In order to handle this scenario , we need to modify the stream analytics query.

對(duì)于上面的示例查詢?nèi)缦拢?em class="showen">

For the above the sample query will as follow,

SELECT test.name,test.date,test.flag,cmd,root,result into[streamanalyticsoutput] 來(lái)自 [streamanalyticsinput]

SELECT test.name,test.date,test.flag,cmd,root,result into [streamanalyticsoutput] from [streamanalyticsinput]

streamanalyticsoutput -- 將是 power bi 輸出別名

streamanalyticsoutput -- will be the power bi output alias

streamanalyticsinput -- 事件中心輸入

streamanalyticsinput -- event hub input

這篇關(guān)于PBI (Power BI) 服務(wù)不支持的 System.Object 類型的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！