How to use Power BI Streaming Datasets in your business applications

Transcript

1. VIRTUAL How to use Power BI Streaming Datasets in your Business Applications Aroh Shukla 20 Mar 2020 Cochin PowerApps and Power Automate User Group
2. About Aroh Technical Consultant, Microsoft MCT & Nintex vTE Experience: Office 365, SharePoint Online, Data Platform Office 365 & Power BI Trainer LinkedIn: https://www.linkedin.com/in/arohshukla/ Blog: aarohblah.blogspot.com Aroh Shukla (Microsoft MCT)
3. Agenda •Types of Streaming Data Sets •Power Automate with Microsoft Forms •Azure Cognitive Services with Power Automate •Two Dashboards •2 Demos •Q and A
4. Streaming/Real-time Data Sets Gives users the capability to stream data and update dashboards in real-time. This can be from various different sources like social media, sensors, etc.…
5. Types of Real-Time Datasets •3 Types of Datasets • Push Datasets • Streaming Dataset • PubNub Dataset
6. Real-Time Push Dataset • Database Created • Reports can be created • Any visuals • Real-Time in Dashboards • Cannot use Pin Live Page • Maintains History • Q and A Works Well
7. Dynamics 365 Office 365 Standalone Apps Microsoft Power platform Azure Common Data Service for Apps and Data Connectors
8. Power Apps An application Platform as a Service (aPaaS) for citizen- developers to build high-productivity business apps
9. Dynamics 365 Office 365 Standalone Apps Microsoft Power platform Azure Common Data Service for Apps and Data Connectors
10. Power Automate Power Automate is a service for business users to automate workflows across apps and services
11. Power Automate is… Workflow automation Routine and Repetitive tasks
12. Triggers and Actions Triggers Sets the flow in motion An Event A Button Scheduled Actions What you want to happen when a trigger is invoked
13. Templates, Templates, Templates
14. Dynamics 365 Office 365 Standalone Apps Microsoft Power platform Azure Common Data Service for Apps and Data Connectors
15. Power BI: experience your data
16. Streaming/Real-time Data Sets
17. What we will do in this Demo? Users Submit Real-Time Data in MS FORMS The FLOW data goes to Power Automate Creating in data set Power BI using Push API Push the data in Power BI within MS FLOW Real-Time Dashboard is displayed in Power BI
18. What we will BUILD!
19. DEMO Time! (Power Automate & Power BI)
20. Microsoft Forms (Guys, some participation ) URL: http://bit.ly/2J12qvo (Provide answer in City, State format. For example New Delhi, Delhi ; Ahmedabad, Gujarat; Bengaluru, Karnataka; Bhopal, Madhya Pradesh)
21. Azure Cognitive Service with PA
23. Gracias Merci