Power BI - Accessing Azure Data Lake Gen 2 Files (11) - Hands On Demo!
Power BI and Azure Data Lake Storage is the key to the future of GREAT BI! Here I show you how to connect your Dashboards and Reports to Azure Storage Gen 2 the cutting edge type of Azure data storage and where current and future data lakes will reside. Also, through a very simple example, I teach you about the basic organization of files in a data lake and how powerful this non-ETL, non-database approach to data storage makes it so powerful. Download Sample Files: https://sqlcoop-my.sharepoint.com/:f:...
00:00 Create Gen2 Data Lake Storage Account and Container
01:10 Upload Files to Container
03:00 Review files' contents
04:08 Power BI - Get Data from Gen2 File Container and Sales folder Url
06:45 Get Storage Account Key
07:02 Error: Access to the resource is forbidden and Role Based Access Control
11:02 Connection Succeeded
11:53 Combine data from multiple files
13:00 Create sample report from data
14:30 Add additional new subfolders and data to container
17:00 Refresh report with new data
( / greg-c-coopman-b07b54103 )