Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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