Unable to call Workspace in Service using Power shell commands

chotu27 — Tue, 14 May 2019 14:39:08 GMT

Hi All,

I am able to connect to Power bi service from powershell using command connect-PowerBIServiceAccount. But when try to call the workspaces using Get_PowerBIworkspace i am getting below error.

PS C:\WINDOWS\system32> Get-PowerBIWorkspace
Get-PowerBIWorkspace : Operation returned an invalid status code 'Unauthorized'
At line:1 char:1
+ Get-PowerBIWorkspace
+ ~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (Microsoft.Power...owerBIWorkspace:GetPowerBIWorkspace) [Get-PowerBIWorkspace], HttpOperationException
    + FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Workspaces.GetPowerBIWorkspace

PS C:\WINDOWS\system32> Resolve-PowerBIError -Last


   HistoryId: 2


RequestId        : 05f5d685-34a9-4d80-9c3e-820fbb3ef520
Response         : Unauthorized (401): {"error":{"code":"UserNotLicensed","message":"User is not licensed for Power BI"}}
PowerBIErrorInfo : UserNotLicensed
ResponseDate     : Tue, 14 May 2019 14:29:29 GMT
RequestMethod    : GET
RequestUri       : https://api.powerbi.com/v1.0/myorg/groups?$top=100
InvocationInfo   : {Get-PowerBIWorkspace}
Line             : Get-PowerBIWorkspace
Position         : At line:1 char:1
                   + Get-PowerBIWorkspace
                   + ~~~~~~~~~~~~~~~~~~~~
StackTrace       :    at Microsoft.PowerBI.Api.V2.Groups.<GetGroupsWithHttpMessagesAsync>d__5.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.PowerBI.Api.V2.GroupsExtensions.<GetGroupsAsync>d__1.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.PowerBI.Api.V2.GroupsExtensions.GetGroups(IGroups operations, String filter, Nullable`1 top, Nullable`1 skip)
                      at Microsoft.PowerBI.Common.Api.Workspaces.WorkspacesClient.GetWorkspaces(String filter, Nullable`1 top, Nullable`1 skip)
                      at Microsoft.PowerBI.Commands.Workspaces.GetPowerBIWorkspace.GetWorkspaces()
                      at Microsoft.PowerBI.Commands.Workspaces.GetPowerBIWorkspace.ExecuteCmdlet()
                      at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord()
HistoryId        : 2

topic Unable to call Workspace in Service using Power shell commands in Developer

Unable to call Workspace in Service using Power shell commands