locked
Input json on blob storage to Power BI RRS feed

  • Question

  • Hello guys,

    I have folloowed this document "Real-time Twitter sentiment analysis in Azure Stream Analytics" :

    https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-twitter-sentiment-analysis-trends

    Everything worked fine but now I'm trying to use Power BI and get data from AZURE BLOB STORAGE that contains json file (generated from Stream Analytics) and when I load it in P. BI it shows me only columns and not data.  Someone can tell me why in Power BI I don't able to view data on json file?

    thanks

    Andrew


    <link href="moz-extension://ee2192be-7cce-4e65-bf37-c247e69e7140/skin/s3gt_tooltip_mini.css" rel="stylesheet" type="text/css" /><style media="print" type="text/css">#s3gt_translate_tooltip_mini { display: none !important; }</style>
    • Edited by Mirko30 Saturday, November 4, 2017 11:23 AM
    Friday, November 3, 2017 3:07 PM

All replies

  • Hi, 

    please share the json file. Reading JSON in PowerBI is staightforward.

    Regards

    Thomas 

    Monday, November 6, 2017 3:46 PM
  • This is an output example:

    {"time":"2017-11-03T14:49:10.0000000Z","topic":"azure","count":2}
    {"time":"2017-11-03T14:49:10.0000000Z","topic":"microsoft","count":5}
    {"time":"2017-11-03T14:49:10.0000000Z","topic":"Inter","count":5}
    {"time":"2017-11-03T14:49:15.0000000Z","topic":"azure","count":1}
    {"time":"2017-11-03T14:49:15.0000000Z","topic":"microsoft","count":7}
    {"time":"2017-11-03T14:49:15.0000000Z","topic":"Inter","count":3}
    {"time":"2017-11-03T14:49:20.0000000Z","topic":"microsoft","count":6}
    {"time":"2017-11-03T14:49:20.0000000Z","topic":"Inter","count":4}
    {"time":"2017-11-03T14:49:25.0000000Z","topic":"azure","count":1}
    {"time":"2017-11-03T14:49:25.0000000Z","topic":"microsoft","count":4}
    {"time":"2017-11-03T14:49:25.0000000Z","topic":"Inter","count":7}
    {"time":"2017-11-03T14:49:30.0000000Z","topic":"microsoft","count":2}
    {"time":"2017-11-03T14:49:30.0000000Z","topic":"Inter","count":3}
    {"time":"2017-11-03T14:49:35.0000000Z","topic":"azure","count":1}
    {"time":"2017-11-03T14:49:35.0000000Z","topic":"microsoft","count":3}
    {"time":"2017-11-03T14:49:35.0000000Z","topic":"Inter","count":1}

    If I try to load in Power BI it tells me : "We found extra characters at the end of JSON input."

    But the file is generated by Stream Analytrics and it makes a JSON output file as "event serialization format"  as well as described from Microsoft document.

    Another test that I have made is create new Azure Streaming Job and get Json streaming file above  as input and then Power BI as Output but this job fails with this error: "The JSON provided in the request body is invalid. Property 'dataset' value length 0 is not in the acceptable range from 1 to 128."

    I don't know what can I do??

    • Edited by Mirko30 Monday, November 6, 2017 7:20 PM
    Monday, November 6, 2017 5:55 PM
  • I got the same error - seems to be an ASA specific bug. 

    For me it worked to import the file as a text file and then "analyze" the string column as json.

    Another workaround could be to format the ASA JSON output as an array.

    Tuesday, November 7, 2017 10:19 AM