SharePoint Designer 2010: Business data connectivity metadata store is unavailable

If you see Business data connectivity metadata store is unavailable error in SP Designer 2010 then try to run the below powershell command. It got resolved the problem for me.

$bcsServiceApp = Get-SPServiceApplication | where {$_ -match "Business Data Connectivity Service"}
$bcsServiceApp.RevertToSelfAllowed = $true;
$bcsServiceApp.Update();