Checking in with Power Apps, Flow and Power BI

In this session we will create an Power App that will allow users to check-in their location. We will then create a Flow that will take that location and write to a Power BI data source and refresh it. We will then create a Power BI report that will display the data on a map.

Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the users location when a button is pressed. Microsoft Flow is similarly a tool that allows you to create data flows and logic with minimal coding. The flow we create in this session will take the location and user information and write it to a Excel. We will then create a custom connector in Flow that will allow us to refresh a Power BI data set. This will mean that the data will be visible in the Power BI report almost as soon as the user presses the checkin button. Power BI is a self-service reporting tool that allows you to connect to multiple data sources and mash up data into a beautiful report or dashboard. In the report we will create in this session we will connect to a Excel file with the location information in it and display it in a report including the location on a map.

The audience will take away useful information about Power Apps, Flow and Power BI including all the code created during this demo.

Ásgeir Gunnarsson

Data Platform MVP

Hafnarfjörður, Iceland

View Speaker Profile