Live data on report vs dashboard using Stream Analytics

[Anonymous]

Hi,

Just looking to better understand live or near-live data visualisation in Power BI. I know you can use Stream Analytics to show live data on a dashboard (I did the Micrsoft tutorials - those are great). When creating the stream job, you have to create a dataset for the stream's output. Could this same dataset be used for a report? And if so, what would the data refresh process look like on the report compared to the dashboard? I have lots of data being sent to an IoT Hub from a single device, so I'd like to have some live stream tiles and pinned reports on my dashboard that reference the same dataset.

Thanks for the help!

Edit: As soon as I posted this, I found this helpful matrix that answers the first question... I'll just leave that here.

[selimovd · Accepted solution]

Hey @Anonymous ,

in Stream Analytics you add a Power BI dataset as an output.

In Power BI you see then this dataset and can start creating a report based on that data set. Be aware that a report doesn't show the "live" change of the data. For that you have to pin individual visuals from that report to a dashboard. When you open the dashboard you see how data changes live while the dashboard is open.

About the refresh, the Stream Analytics is just pushing the data to the data set. This means you don't have to schedule a refresh as the data is pushed in anyway.

Hope that clarified your questions. Otherwise just let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd · Accepted solution]

Hey @Anonymous ,

in Stream Analytics you add a Power BI dataset as an output.

In Power BI you see then this dataset and can start creating a report based on that data set. Be aware that a report doesn't show the "live" change of the data. For that you have to pin individual visuals from that report to a dashboard. When you open the dashboard you see how data changes live while the dashboard is open.

About the refresh, the Stream Analytics is just pushing the data to the data set. This means you don't have to schedule a refresh as the data is pushed in anyway.

Hope that clarified your questions. Otherwise just let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Hi @selimovd ,

Thanks for your response and insights! If I pin a whole report page as opposed to individual visuals onto my dashboard, will the data in the pinned report be live or does that only work with pinning individual visuals?

Regards,

Emiko

[selimovd · Accepted solution]

Hey @Anonymous ,

no, that works also with a pinned report.

It just doesn't look as good from my point of view. But give it a try.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic