How to retrieve data from Azure Datalake using Dataflow in Power BI

We'll learn the techniques

1. Grant access profile to

   Azure Data Lake resource:
   • Use the Azure portal to configure access control (ACCESS CONTROL) and assign roles (ROLE ASSIGNMENT) to users or services that need to interact with Azure Data Lake.
Get Azure Data Lake file system URL: Find the Azure

2. Data Lake file

   • system (ENDPOINTS) URL in the Azure portal to establish the connection between Power BI and the data store.
Create new dataflow
3. :
   • In Power BI Service, create a new dataflow (DATAFLOW) to manage and prepare the data, adding new tables (ADD NEW TABLES) as needed.

Transform data in Power BI Service
4. :
   • Use the Power Query feature in Power BI Service to perform transformations on data, apply filters (FILTER DATA), and remove unnecessary columns (REMOVE OTHER COLUMNS) for efficient modeling.

Get data from Power BI dataflow
5. : In Power BI
   • Desktop or the service, use the "Get Data" option to import data from Power BI dataflow and integrate it into the current data model.