Consider the following scenario:
- I am building a data platform on Microsoft Fabric, using Lakehouses as the primary storage engine.
- My end users need to consume data from the data platform as users of Power BI reports which connects to data from the Lakehouses, as developers of ad hoc models and report using data from the Lakehouses, and through ad hoc SQL queries on the Lakehouses.
- I want to use DirectLake for Power BI reports to take advantage of frequency data ingestion and transformation, and improve the actionability of my reports.
- My data is sensitive, and users, regardless of whether they consume reports or develop their own, need to be restricted by Row Level Security to only see some of the data.
Read on for eight different approaches to the problem and Jon’s thoughts on each approach.