This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 7 | |
| 7 | |
| 7 |
| User | Count |
|---|---|
| 28 | |
| 26 | |
| 22 | |
| 21 | |
| 18 |