Forum Discussion

liey87's avatar
liey87
Frequent Visitor
9 years ago
Solved

Dataset is not created from azure stream analytics output sink

Guys,

 

I've been through this for some times. Really bugging me now. Today I have create a new version of simple data sending to IoT-Hub. Then stream analytics will stream incoming data from IoT-Hub as Input and sink into PowerBi Pro Account as Output. On the Query, I have made simple

 

SELECT
*
INTO
[outgoing]
FROM
[incoming]

 

But turns out, no dataset were created on PowerBi "Dataset". This been happening for 3 projects where no dataset has been auto create at the time, stream analytics process it. Does anyone have the idea? Direct streaming dataset using API is not a problem but the architecture is must be through Azure services and this is the problem I'm facing, no new dataset were created after process on Stream Analytics. Need some clarification and advice

  • Hi v-haibl-msft

     

    Yeah. I found that the dataset is exist on Streaming Dataset part, not like previous which in datasets panel.

     

    So which mean, its can be Real-Time Streaming. This was great. Thanks

7 Replies

  • liey87's avatar
    liey87
    Frequent Visitor

    Hi v-haibl-msft

     

    Yeah. I found that the dataset is exist on Streaming Dataset part, not like previous which in datasets panel.

     

    So which mean, its can be Real-Time Streaming. This was great. Thanks

    • VinayN's avatar
      VinayN
      Regular Visitor

      Hello everyone,

      I am facing a similar issue. My query is quite simple:
      SELECT
      *
      INTO
      [OutputJob]
      FROM
      [InputJob]

      Input Job is receiving input data from Event Hub and is tested successfully.

      Output Job is pointed to Power BI, creating a new DataSet and a new Table. But, I do not see the new DataSet and the Table in the Power BI under my selected Work Space. Please provide me some inputs.

      Also, as per the link:
      http://community.powerbi.com/t5/Integrations-with-Files-and/Dataset-is-not-created-from-azure-stream-analytics-output-sink/m-p/98474#M7025

      I have mailed my Azure Subscription ID and the region i want to see the data in, to [email protected]
      But, i haven't heard back anything from them as well.

      Thanks in advance!

    • Anonymous's avatar
      Anonymous
      Not applicable

      liey87, Where is the streaming dataset part, the place where your dataset was sitting instead of my workspace-->dataset ? Can you please send a snapshot?

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee

    liey87

     

    Are you using the feature introduced in this blog? It seems that it is available for private preview and you need to email [email protected] with your Azure subscription ID and the region you’d like to enable for private preview.

    And there is a step to step guide here and the dataset is created in the end.

     

    Best Regards,

    Herbert

  • I do have the same problem. When I create a connection in stream analytics to power bi, it's not creating a dataset in power bi. Does anyone has a solution for that?

     

     

  • I do have the same problem. When I make a connection with stream analytics in azure portal, the dataset is not going to be created in the power bi. Is there a solution?

  • I'm facing the same issue. Does anyone has a solution for that?