We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.