In this section, we explain how to load data from the Fabric Lakehouse into Power BI and Excel.

In Power BI, you can load data using Direct Lake or via the SQL Endpoint. Both methods have advantages and disadvantages, which we will explain in this section.

In Excel, data can be loaded using the SQL Endpoint.