Difference between dedicated storage (Azure Datalake Gen 2) workspace vs system default - Power BI

[Pranesh_K]

Hi Team,

I am going through the subscriptions of ADLS gen2 storage. I have a questions what are the pros of cons of using ADLS Gen2 dedicated storage Workspace in Power BI service  on comparison to default system workspace. Please provide me detailed points.

Thanks in advance.

[aj1973]

Hi @Pranesh_K 

Azure Data Lake Storage Gen2 is a set of capabilities dedicated to big data analytics, built on Azure Blob Storage. Data Lake Storage Gen2 converges the capabilities of Azure Data Lake Storage Gen1 with Azure Blob Storage. For example, Data Lake Storage Gen2 provides file system semantics, file-level security, and scale. Because these capabilities are built on Blob storage, you also get low-cost, tiered storage, with high availability/disaster recovery capabilities. Data Lake Storage Gen2 makes Azure Storage the foundation for building enterprise data lakes on Azur...1.

In Power BI, a workspace is a shared environment for collaborating on Power BI content with colleagues. A workspace can be created in a dedicated capacity or in a shared capacity. In a shared capacity, the workspace uses the system default storage account. In a dedicated capacity, the workspace uses a dedicated storage account. A dedicated capacity provides more control over the resources used by the workspace and can provide better performance and scalability for large workloads. A dedicated capacity also allows you to use Azure Data Lake Storage Gen2 as the storage account for ...2.

Therefore, the main difference between a dedicated storage (Azure Data Lake Gen2) workspace and a system default workspace is that the former uses a dedicated storage account, which provides more control over resources, better performance, and scalability for large workloads. The latter uses the system default storage account, which is shared across all workspaces in the sam...