Add-AzTableRow throws error MethodInvocationException : The specified resource does not exist

Question

Hello,

I ran into this error when I try to add new row while using the ConnectedAccount context rather than a key based authentication.

MethodInvocationException: Exception calling "Execute" with "1" argument(s): "The specified resource does not exist."  

This is the script code:

Connect-AzAccount  
Set-AzContext -Subscription "<subscription name>"  
$storageAccount = Get-AzStorageAccount -ResourceGroupName "<resoruce group name" -Name "<storage account name>"  
$Context = New-AzStorageContext -StorageAccountName "<storage account name>" -UseConnectedAccount  
$tableName = "testTable"  
New-AzStorageTable –Name $tableName –Context $Context   
      
Get-AzStorageTable –Context $Context | select Name  
$storageTable = Get-AzStorageTable –Name $tableName –Context $Context  
$cloudTable = $storageTable.CloudTable  
$partitionKey1 = "partition1"  
$partitionKey2 = "partition2"  
      
Add-AzTableRow `  
    -table $cloudTable `  
    -partitionKey $partitionKey1 `  
    -rowKey ("CA") -Property @{"username" = "Dude"; "userid" = 1 }  
      
Add-AzTableRow `  
    -table $cloudTable `  
    -partitionKey $partitionKey2 `  
    -rowKey (XY) -property @{"username" = "Christine"; "userid" = 3 }  

How to fix this error?

Thank you.

Answer 1

@Mohamed Sahbi From Authorizing table data operations:

The AzTable PowerShell module supports authorization with the account access key via Shared Key authorization. The examples in this article show how to authorize table data operations via Shared Key.

Azure Table Storage supports authorization with Azure AD. However, the AzTable PowerShell module does not natively support authorization with Azure AD. Using Azure AD with the AzTable module requires that you call methods in the .NET client library from PowerShell.

Hope this helps. Please let us know if you have any more questions and we will be glad to assist you further. Thank you!

Remember:

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.