Forum Discussion
Realtime Reports
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
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.
3 Replies
- lbendlinSuper User
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.
- MadhavDholakiaHelper I
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.
- lbendlinSuper User
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