Creating Power BI dataflows with connections to source data

The Power BI Desktop Power Query work from previous chapters is connected to data sources from your local machine. Power BI dataflows is a very similar tool to Power Query, but connectivity happens from the Power BI cloud service. When creating your dataflows, you will need to consider connectivity to the data sources. Earlier in this book, you determined that the sources of data for the FAA Wildlife Strike database were as follows:

• wildlife.accdb: All of the historical FAA Wildlife Strike reports. This file is an Access database that’s been downloaded in ZIP file format from the FAA website.
• read_me.xls: Descriptive information about the data in the Database.accdb database file. This file is an Excel file that was downloaded within the same ZIP file as the Access database. The file has been changed to a .xlsx extension in the Packt GitHub repository and is available in the folder at https://github.com/PacktPublishing...