cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!