topic Re: Realtime Reports in Developer

Realtime Reports

MadhavDholakia — Fri, 21 Jun 2024 13:49:47 GMT

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

Re: Realtime Reports

lbendlin — Fri, 21 Jun 2024 17:29:55 GMT

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.

Re: Realtime Reports

MadhavDholakia — Tue, 02 Jul 2024 13:32:16 GMT

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.

Re: Realtime Reports

lbendlin — Tue, 02 Jul 2024 15:52:58 GMT

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