DirectLake over OneLake dataset with RLS or SSO Enabled?

Hi jaryszek,

Thank you for your patience and for remaining engaged in this extensive discussion. We also apologize for any inconvenience caused.
Based on our comprehensive discussion, please find below a consolidated summary and final clarification for the members of the community.
The thread focused on clarifying whether the Power BI ExecuteQueries REST API can be used with a semantic model built using Direct Lake over OneLake, particularly when accessed using a Service Principal or a user identity, and in the absence of RLS and data source SSO configuration.
The misunderstanding arose because the official documentation for the ExecuteQueries REST API does not explicitly mention Direct Lake. It only states that datasets hosted in Azure Analysis Services or datasets using live connections are not supported.
After verification with Support, it was confirmed that Direct Lake semantic models utilize a live connection. Testing demonstrated that ExecuteQueries works with Import mode datasets but fails with Direct Lake semantic models.

Once again we thank you for your time and cooperation.

Please continue to use the Microsoft Fabric Community for any further queries.
Thank you.