If you are using Synapse Analytics with SQL Pool Serverless (former SQL Pool On demand) and you want to manage a notion of “principle of least privilege”, there are a few things to take into account. The creation of a USER using for example an AD group: With [MyAdGroup], a group in the Active Directory to which we want to…

The first difficulty in discussing an AAS / PowerBI functionality is to create a test environment that is interesting enough. StackOverflow proposed by Brent Ozar looks like a good fit. The Extra-Large version has the merit of making more than 300 GB of data and of providing several areas of interesting analysis. The tabular model used for this example is…

Storage accounts with Hierarchical Namespace activated (also called Azure Data Lake Storage Gen 2) have the main advantage of managing access via Azure AD authentication and therefore being able to give rights to a UPN (POSIX rights). However, for compatibility purposes, a large part of the blob API remains accessible, so it is possible to continue to authenticate with the…