cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CezarSteinz
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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.