How do you connect a Fabric lakehouse to Power BI for analytics?

• A. Use a live connection or scheduled refresh to the Fabric lakehouse tables via Power BI, enabling BI dashboards with direct query or imported data.
• B. It is not possible to connect Power BI to Fabric lakehouse.
• C. You must export data to CSV files before analysis.
• D. Only third-party tools can query the lakehouse; Power BI is unsupported.

Answer: (A)

Connecting a Fabric lakehouse to Power BI uses a standard SQL-based endpoint from the lakehouse and the Power BI connector. You can choose a live connection (DirectQuery) so visuals query the lakehouse in real time, or you can import data into Power BI and enable a scheduled refresh to keep the model updated on a cadence you choose. DirectQuery keeps data in the lakehouse, providing the latest values but relying on query performance from the source, while import mode brings data into Power BI’s in-memory engine for fast visuals at the cost of potential lag between refreshes. This is supported, so you don’t need to export to CSV or use third-party tools.