Exception calling "Connect" with "1" argument(s): "Failed to resolve PBI workspace

[stephanStv]

I've got an issue when using this task for PowerBI workspaces. We have been using it for AAS for a while but switching because of premium.

`##[debug]Loading tabular database from server

[debug]Leaving D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\deploy-aas-db.ps1.

[debug]Caught exception from task script.

[debug]Error record:

[debug]D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\deploy-aas-db.ps1 : Error connecting to tabular service. (Exception calling "Connect" with "1" argument(s): "Failed to resolve PBI workspace. Description:

[debug]

[debug]Technical Details:

[debug]RootActivityId: bbbf121c-90f4-0001-7ea4-a45eca68d801.")

[debug]At line:1 char:1

[debug]+ . 'D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5 ...

[debug]+ ~~~~~~~~~~~~~~~~~

[debug] + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException

[debug] + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,deploy-aas-db.ps1

[debug]

[debug]Script stack trace:

[debug]at , D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\deploy-aas-db.ps1: line 258

[debug]at , : line 1

[debug]at , : line 22

[debug]at , : line 18

[debug]at , : line 1

[debug]Exception:

[debug]Microsoft.PowerShell.Commands.WriteErrorException: Error connecting to tabular service. (Exception calling "Connect" with "1" argument(s): "Failed to resolve PBI workspace. Description:

[debug]

[debug]Technical Details:

[debug]RootActivityId: bbbf121c-90f4-0001-7ea4-a45eca68d801.")

[error]Error connecting to tabular service. (Exception calling "Connect" with "1" argument(s): "Failed to resolve PBI workspace. Description:

Technical Details: RootActivityId: bbbf121c-90f4-0001-7ea4-a45eca68d801.")

[debug]Processed: ##vso[task.logissue type=error]Error connecting to tabular service. (Exception calling "Connect" with "1" argument(s): "Failed to resolve PBI workspace. Description: %0D%0A%0D%0ATechnical Details:%0D%0ARootActivityId: bbbf121c-90f4-0001-7ea4-a45eca68d801.")

[debug]Processed: ##vso[task.complete result=Failed]

`

• SPN is admin on the workspace
• Workspace is premium
• Might be the service connection? What sort of URL is supposed to go into the 'Server URL'

[stephanStv]

Discovered our issue, the SPN was not part of the group that is allowed to use the Power BI API.