MS Fabric as a data source

Objects (data sources) within  the Microsoft Fabric organizational environment can be easily leveraged in the Power BI Desktop application to create reports. These can be: Lakehouse, Warehouse, Datamarts (segments of the data warehouse, grouped by functional units, suitable for reporting), SQL Databases, KQL Databases… In this article, you will learn how to use Lakehouse tables to create reports.

Combining files

Power Query gives us the ability to combine multiple files which belong to one folder. These can be TXT or CSV files, but in practice we will usually combine several Excel files. This is a very powerful option that can save us a lot of time. At the same time, it brings with it some challenges, which you will be able to learn more about in the following text …