Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combining streaming and historical data on one dashboard

Hello everyone! I have a dataset that is created by the Azure Streaming Analytics task. And I have historical data in Azure Synapse Analytics. I need to make a Power BI dashboard that will have str...
Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    4 years ago

    Currently your only option is a hybrid streaming dataset with history enabled. Any "enrichment" needs to be part of the pushed rows.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

At the moment you cannot combine a streaming dataset with other sources.  Microsoft had mentioned at Ignite that they have plans to enable that later.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the answer lbendlin !

    In this case, what is the best way to solve the problem?
    I think it is possible to enrich streaming data through reference values in the Azure Stream Analytics task.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Currently your only option is a hybrid streaming dataset with history enabled. Any "enrichment" needs to be part of the pushed rows.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        lbendlin , could you explain what is meant here. What is "hybrid streaming dataset with history enabled" and what tools can I use to do it?