Realtime Reports

[MadhavDholakia]

Hello, I have just started using Power BI a couple of weeks back - I am now assigned to create a real-time report/dashboard for a telephony system.

There are different end-points from Telephony System to be used, like "CallsOK", "CallsKO", "RTAgentsLoggedIN", "RTCallsBeingProc" etc...

Using Power BI Service, Streaming Dataset Models for all these endpoints are created. Now, on report/dashboard I need to show details which require multiple endpoints:

for example, "CallsOK" AND "CallsKO" to get the total number of calls - "RTCallsBeingProc" and "RTAgentsLoggedIN" to display another required info. I do not see a way to add more than one of these streaming data sets to create a report.  

This might not be the correct option/design for my requirement at all - but in any case, can someone please help with some reference link or details on how this can be designed?

Thank you.

Regards,

Madhav

[lbendlin · Accepted solution]

This is unfortunately correct - streaming datasets only support single tables.  You can consider to use push datasets instead - there you can have multiple tables. Of course push datasets come with their own limitiations, like the absence of sliding windows.

Worth considering the real time capabilities of Fabric.

[MadhavDholakia]

Hi @lbendlin - apologies for the delayed response. so if I understand Push Datasets correctly - the ones I have created are Push Datasets (Historic data analysis is ON)

Is this a correct way to create Push Dataset? How can I us multiple of these Push Datasets in a single report?

Thank you.

[lbendlin]

No, push datasets don't have a concept of "history".  You can fill them up to their 5M row limit and then have to reset them.  This is different from Streaming datasets that can have a FIFO sliding window.

Push Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Learn