cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CezarSteinz Frequent Visitor
Frequent Visitor

Power BI Real-Time Report with Dynamics 365

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.

Cezar Steinz

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)