Forum Discussion
Direct Lake fallback to Direct Query due to SQL security?
Thank you Anonymous!
Power BI queries on a warehouse in Direct Lake mode will fall back to Direct Query mode to abide by row-level security.
Does this also apply to the SQL Analytics Endpoint?
How about when using SQL Granular Permissions (not RLS).
Will that also make Direct Lake fallback to DirectQuery?
If yes, will Direct Lake fall back to DirectQuery for all report users on that Warehouse / SQL Analytics Endpoint, or only for those users for whom SQL Granular Permissions have been defined?
Hi fabricator1 ,
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Hi fabricator1 ,
Apologies for the delay in reply from our side.
Unfortunately we didn't get any update from the internal team regarding the ask.
I kindly request you to raise a support-ticket here. Our team will coordinate with you and help you with the same.
After creating a Support ticket please provide the ticket number as it would help us to track for more information. Hope this helps. Please let us know if you have any other queries.Hello fabricator1 ,
We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket.
Incase if created, please provide the ticket number as it would help us to track for more information.
Thanks,
Gopi Krishna Chenna