locked
No datasets were create on PowerBi RRS feed

  • Question

  • Guys,

    I have attempt this situation for quite some projects. Where the Azure Stream Analytics not sink into PowerBi Workspace datasets. I have create a new resources group to test simple device-to-cloud and cloud-to-display. In ASA Query, I even write

    SELECT * INTO [outgoing-pbi] FROM [incoming-stream]

    Unfortunately, no datasets were created. The iot-hub data is increasing and can be viewed using IoT-Hub Explorer. Can someone help to clarify this issue?


    Code make everything

    Tuesday, December 6, 2016 2:37 AM

Answers

  • Hi Ming Lu,

    I have ask in Power Bi community too:-

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

    I thought there is a problem on ASA output to PowerBi, which I was not aware that it already created in Streaming Dataset instead of Dataset section as previous. I was feeling good using new PowerBi features of real-time streaming dataset and line chart with minutes window. Such great for monitoring real-time data which send data in Azure services



    Code make everything

    Saturday, December 10, 2016 12:51 AM

All replies

  • Can u please follow up this blog and let us know what you found?

    Please always first check the output events metric, whether your pipeline has output https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring

    https://blogs.msdn.microsoft.com/streamanalytics/2015/07/13/tips-for-troubleshooting-stream-analytics-jobs-with-powerbi-output/

    Tuesday, December 6, 2016 5:03 AM
  • Hi Ming Lu,

    I have ask in Power Bi community too:-

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

    I thought there is a problem on ASA output to PowerBi, which I was not aware that it already created in Streaming Dataset instead of Dataset section as previous. I was feeling good using new PowerBi features of real-time streaming dataset and line chart with minutes window. Such great for monitoring real-time data which send data in Azure services



    Code make everything

    Saturday, December 10, 2016 12:51 AM