Gilbert Quevauvilliers runs a test:
After my previous blog post on the different semantic model options and at the same time working with a Fabric customer, it got me thinking which is faster and which consumes less capacity when ingesting data into Power BI either via the SQL Endpoint to a Lakehouse or a query from the Warehouse.
Below you will find the information which I found very interesting indeed.
For both the Lakehouse and Warehouse source CSV’s there was a total of 237,245,585 rows.
Click through for the numbers, and a scenario in which the warehouse loads data faster than a lakehouse.