Power BI Service : System.Object type is not supported

0 votes

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}
Feb 6 in Power BI by Upasana
• 8,470 points
22 views

1 answer to this question.

0 votes

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]

answered Feb 6 by Shubham
• 13,210 points

Related Questions In Power BI

0 votes
1 answer

Is it possible to manage limits while using dedicated capacity power bi embedded app service?

These limits are not related to using ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,080 points
43 views
0 votes
1 answer
0 votes
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,080 points
1,636 views
0 votes
1 answer

Is government, academic and nonprofit pricing available for Power BI?

Yes, nonprofit pricing is available when purchasing ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 37,420 points
40 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
60 views
0 votes
1 answer

How to assign Power BI license to a new user

The assign license method of MS Graph API might ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 37,420 points
47 views
0 votes
1 answer

Where is Power Bi being hosted?

Power BI is currently cloud hosted by ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 37,420 points
69 views
0 votes
1 answer

Power BI Report Viewing on Local Repository?

Use REST API to embed the reports in ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 37,420 points
60 views
0 votes
1 answer

Embedding Power Bi Report Promise is not defined powerbi.js

IE does not yet support Promise. You ...READ MORE

answered Oct 30, 2018 in Power BI by Shubham
• 13,210 points
234 views
0 votes
1 answer

Power BI : Time-based drill downs powered by Azure Data Warehouse

I don't really think you need to ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,210 points
54 views