Power BI Service System Object type is not supported

Question

What I have done here is I've set Azure Stream Analytic job output as Power BI. But I keep getting this warning which says System.Object type which is not supported by PBI service.

Also I can't see any data in Power BI despite being able to see the database created. This probably means that stream analytic job output is being generated.

Below is the sample data sent to Power BI. Is there anything I can do 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}

Answer 1

You have to modify the stream analytics query with an output alias & a hub input.

In your case, the query will be the following;

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