Azure AD Security Group In Lakehouse SQL analytics endpoint
Hello, Can I access AD Security group in Lakehouse SQL analytics endpoint? I tried IS_MEMBER ('AnyGroupName') function. But it didn't work. It returned "NULL". Do you have any idea? My aim is to create RLS security in SQL with Security Groups. Below link says for IS_MEMBER function: "... current user is a member of a database role or a Windows domain group." https://learn.microsoft.com/en-us/sql/t-sql/functions/is-member-transact-sql?view=sql-server-ver16 Thanks in advance.
Publishing Report to Workspace Creates Extra Dataset
I am publishing a report created in Power BI Desktop. The data source is a connection to a Power BI Dataset created via Lakehouse SQL Endpoint. However when I publish that new report, it publishes a new dataset with it. Is it possible to just publish the report since the dataset it is referencing is already published in the service? I now have to update two datasets instead of just one due to this. Here is the flow of how it currently looks: I want to keep the dataset with the green checkmark and remove the one with the red X, while keeping the report working.
db_owner & dms$system.UserQueries
Is it possible to access the db_owner role of a datamart database through SSMS? Even as an admin_user there is no permissions to grant, no extended events and some restricted tables Additionally is it possible to query dms$system.UserQueries? the schema seems to be restricted by default
