Power BI — many files from Data Lake

Short story. You want to import file from Data Lake into Power BI.

I have three files in my Data Lake.

First case — more obvious.

You can ‘expand’ all files choosing ‘Combine & Load/Transform Data while you connectiong to ADL.

Your data is avilable in Power BI and ready to work with.

Second way — not so obvious.

File references are inside Power Bi. You can expand them in Power Query Editor. Select ‘Combine Files’ button.

Files have been expanded.




Data | BI Engineer (Microsoft Stack)

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium


Phil Sturgeon, Transforming APIs @ WeWork

Being productive in OSCP and beyond

Creating N1QL Labelled Image Database using Couchbase, FastAPI, and SerpApi

Casting in python

Algorithm Practice: Squares of a Sorted Array

Sysmon: Getting Started

Does Fedora Silverblue fix the biggest problem Linux has?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Michal Molka

Michal Molka

Data | BI Engineer (Microsoft Stack)

More from Medium

Power BI — auto refresh dataset after dataflow

Cleaning Up Messy Data in Power Query

Handling Errors in DAX — Power BI

7 Best Practices to Optimize Power BI Model