Currently I have a Power BI Pro account and a dev Dynamics 365, where I need create a real-time Report showing a table with all emails created in last hour and a dashboard showing the amount of emails per minute.
I've read many posts / websites talking about API / PubNub, already created some examples using Stream API and mapped the column which I need to create my table (createdon, subject) but it doesn't work. After that I build another API and put a Microsoft Flow to be triggered when a new email appear on Dynamics 365 email table, send this item to Power BI dataset, it works but not as I wish (I need to refresh my report to show the new data). I have many questions about real-time integration (I'm a newbie in real-time reports yet):
- Is it possible to have a real-time Report with table, matrix and everything? (I'm saying report, not a dashboard with tile...)
- If yes, how could I create a real-time Report? (Based on what I said, API / PubNub doesn't work for my report)
- And, in addition, there is some way to transform real-time data that comes from API? or create measures? (Because for dashboard example, i have only createdon and subject, so I need a "count" measure to build a dashboard)
- If no, there is some way to create something similar on Power BI?
Sorry for my bad english and thanks in advanced.