Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
How can a GUID be used in the code below instead of a Workspace Name? Our workspaces have business freindly names.
I have tried simpy changing "myworkspace" to a real GUID in our tennant. I have even tried to create the variable as GUID type. I have tried all lower case letters in the GUID and all upper case letters in the GUID.
The error is:
Get-AzDataLakeGen2ChildItem : WorkspaceId and ArtifactId should be either valid Guids or valid Names
Status: 400 (BadRequest)
ErrorCode: BadRequest
Content:
{"error":{"code":"BadRequest","message":"WorkspaceId and ArtifactId should
https://learn.microsoft.com/en-us/fabric/onelake/onelake-powershell
Install-Module Az.Storage -Repository PSGallery -Force
Connect-AzAccount
$ctx = New-AzStorageContext -StorageAccountName 'onelake' -UseConnectedAccount -endpoint 'fabric.microsoft.com'
# This example uses the workspace and item name. If the workspace name does not meet Azure Storage naming criteria (no special characters), you can use GUIDs instead.
$workspaceName = 'myworkspace'
$itemPath = 'mylakehouse.lakehouse/Files'
# Recursively get the length of all files within your lakehouse, sum, and convert to GB.
$colitems = Get-AzDataLakeGen2ChildItem -Context $ctx -FileSystem $workspaceName -Path $itemPath -Recurse -FetchProperty | Measure-Object -property Length -sum
"Total file size: " + ($colitems.sum / 1GB) + " GB"
Solved! Go to Solution.
Resolved by MS support at my employer. If you use a workspace GUID, then you must also use a Lakehouse GUID. I was using only the workspace GUID due to the name being incompatible.
To use the Workspace GUID in the Get-AzDataLakeGen2ChildItem cmdlet, you must also use the Lakehouse GUID instead of the Lakehouse name.
The Workspace GUID and Lakehouse GUID can be retrieved by:
Go to the workspace > Your Lakehouse > Open > URL: https://app.powerbi.com/groups/<workspaceGUID>/lakehouses/<LakehouseGUID>?experience=power-bi
Ensure that Lakehouse is selected at the top right hand side
Resolved by MS support at my employer. If you use a workspace GUID, then you must also use a Lakehouse GUID. I was using only the workspace GUID due to the name being incompatible.
To use the Workspace GUID in the Get-AzDataLakeGen2ChildItem cmdlet, you must also use the Lakehouse GUID instead of the Lakehouse name.
The Workspace GUID and Lakehouse GUID can be retrieved by:
Go to the workspace > Your Lakehouse > Open > URL: https://app.powerbi.com/groups/<workspaceGUID>/lakehouses/<LakehouseGUID>?experience=power-bi
Ensure that Lakehouse is selected at the top right hand side
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 45 | |
| 44 | |
| 42 | |
| 15 | |
| 15 |