PBI（Power BI）服务不支持的System.Object类型 [英] System.Object type which is not supported by PBI (Power BI)service

问题描述

我已将Azure流分析作业输出设置为Power BI。但是我在分析作业中收到警告，提示 System.Object类型不受PBI服务支持。

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.

我也无法在Power BI中查看任何数据。但是我可以看到在那里创建的数据库可以确保流分析作业的输出在那里。

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.

下面是发送到Power BI的示例数据。我知道发生错误是因为属性之一是对象。我在Power BI上可以做些什么来解决这个问题？

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.

对于上述示例查询，如下所示，

For the above the sample query will as follow,

选择 test .name， test .date， test .flag，cmd，root，从[streamanalyticsinput]

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

streamanalyticsoutput输出到
[streamanalyticsoutput] bi输出别名

streamanalyticsoutput -- will be the power bi output alias

streamanalyticsinput-事件中心输入

streamanalyticsinput -- event hub input

这篇关于PBI（Power BI）服务不支持的System.Object类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！