maikvandergaag
commented
2 years ago Could you share the complete log file
Closed NV2601 closed 2 years ago
maikvandergaag
commented
2 years ago Could you share the complete log file
NV2601
commented
2 years ago 2022-04-28T20:31:40.1653796Z ##[debug]Evaluating condition for step: 'Power BI Action: AddSP'
2022-04-28T20:31:40.1655839Z ##[debug]Evaluating: succeeded()
2022-04-28T20:31:40.1656325Z ##[debug]Evaluating succeeded:
2022-04-28T20:31:40.1657538Z ##[debug]=> True
2022-04-28T20:31:40.1658062Z ##[debug]Result: True
2022-04-28T20:31:40.1658498Z ##[section]Starting: Power BI Action: AddSP
2022-04-28T20:31:40.1780369Z ==============================================================================
2022-04-28T20:31:40.1780684Z Task : Power BI Actions
2022-04-28T20:31:40.1780908Z Description : Release Task Power BI Actions
2022-04-28T20:31:40.1781118Z Version : 5.4.31
2022-04-28T20:31:40.1781299Z Author : Maik van der Gaag
2022-04-28T20:31:40.1781469Z Help :
2022-04-28T20:31:40.1781707Z ==============================================================================
2022-04-28T20:31:40.9304586Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2022-04-28T20:31:41.0541483Z Starting Power BI Actions extension
2022-04-28T20:31:41.0670365Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1.
2022-04-28T20:31:41.0745803Z ### Required Module is needed. Importing now...
2022-04-28T20:31:41.0793785Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2022-04-28T20:31:41.0870711Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2022-04-28T20:31:41.0959144Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2022-04-28T20:31:41.1155934Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2022-04-28T20:31:41.1187287Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2022-04-28T20:31:41.1274095Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-28T20:31:41.1323955Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-28T20:31:41.1325316Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2022-04-28T20:31:41.1328069Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-28T20:31:41.1349358Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2022-04-28T20:31:41.1364518Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2022-04-28T20:31:41.1382041Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2022-04-28T20:31:41.1399341Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2022-04-28T20:31:41.1417142Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2022-04-28T20:31:41.1434200Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2022-04-28T20:31:41.1451617Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2022-04-28T20:31:41.1468943Z ##[debug]Importing alias 'Login-PowerBI'.
2022-04-28T20:31:41.1486163Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2022-04-28T20:31:41.1503302Z ##[debug]Importing alias 'Logout-PowerBI'.
2022-04-28T20:31:41.1520552Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2022-04-28T20:31:41.1537775Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2022-04-28T20:31:41.1555441Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2022-04-28T20:31:41.1589893Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2022-04-28T20:31:41.1752083Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2022-04-28T20:31:41.1859673Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2022-04-28T20:31:41.1891948Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2022-04-28T20:31:41.1974550Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-28T20:31:41.1980967Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2022-04-28T20:31:41.3061948Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-28T20:31:41.3071261Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2022-04-28T20:31:41.3073019Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-28T20:31:41.3101559Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2022-04-28T20:31:41.3122762Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2022-04-28T20:31:41.3163277Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2022-04-28T20:31:41.3164476Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2022-04-28T20:31:41.3179128Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2022-04-28T20:31:41.3196805Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2022-04-28T20:31:41.3212857Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2022-04-28T20:31:41.3229273Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2022-04-28T20:31:41.3245163Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2022-04-28T20:31:41.3261258Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2022-04-28T20:31:41.3277390Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2022-04-28T20:31:41.3293470Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2022-04-28T20:31:41.3310419Z ##[debug]Importing alias 'New-PowerBIGroup'.
2022-04-28T20:31:41.3326639Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2022-04-28T20:31:41.3342773Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2022-04-28T20:31:41.3358678Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2022-04-28T20:31:41.3392341Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2022-04-28T20:31:41.3455826Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2022-04-28T20:31:41.3482675Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2022-04-28T20:31:41.3534352Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2022-04-28T20:31:41.3563584Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2022-04-28T20:31:41.3567828Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2022-04-28T20:31:41.3584559Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2022-04-28T20:31:41.3600753Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2022-04-28T20:31:41.3616767Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2022-04-28T20:31:41.3632672Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2022-04-28T20:31:41.3648733Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2022-04-28T20:31:41.3664963Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2022-04-28T20:31:41.3680865Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2022-04-28T20:31:41.3697623Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2022-04-28T20:31:41.3713497Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2022-04-28T20:31:41.3729544Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2022-04-28T20:31:41.3745230Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2022-04-28T20:31:41.3761402Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2022-04-28T20:31:41.3777404Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2022-04-28T20:31:41.3793618Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2022-04-28T20:31:41.3809465Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2022-04-28T20:31:41.3825587Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2022-04-28T20:31:41.3841382Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2022-04-28T20:31:41.3857355Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2022-04-28T20:31:41.3890213Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2022-04-28T20:31:41.3954425Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2022-04-28T20:31:41.4214622Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2022-04-28T20:31:41.4246019Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2022-04-28T20:31:41.4302036Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2022-04-28T20:31:41.4316249Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2022-04-28T20:31:41.4332650Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2022-04-28T20:31:41.4348746Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2022-04-28T20:31:41.4364944Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-28T20:31:41.4381186Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2022-04-28T20:31:41.4397163Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2022-04-28T20:31:41.4413690Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2022-04-28T20:31:41.4429721Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2022-04-28T20:31:41.4445514Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2022-04-28T20:31:41.4461013Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2022-04-28T20:31:41.4478280Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2022-04-28T20:31:41.4494137Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2022-04-28T20:31:41.4509951Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2022-04-28T20:31:41.4526326Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2022-04-28T20:31:41.4542294Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2022-04-28T20:31:41.4558069Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2022-04-28T20:31:41.4574235Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2022-04-28T20:31:41.4590316Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2022-04-28T20:31:41.4606104Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2022-04-28T20:31:41.4621992Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2022-04-28T20:31:41.4637819Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2022-04-28T20:31:41.4653871Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2022-04-28T20:31:41.4669981Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2022-04-28T20:31:41.4685891Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2022-04-28T20:31:41.4701364Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2022-04-28T20:31:41.4717141Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2022-04-28T20:31:41.4732735Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2022-04-28T20:31:41.4742474Z ### Trying to import the incorporated module for PowerBI
2022-04-28T20:31:41.4764449Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1'.
2022-04-28T20:31:41.4914606Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-28T20:31:41.4931204Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-28T20:31:41.4947438Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2022-04-28T20:31:41.4963675Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-28T20:31:41.4979804Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2022-04-28T20:31:41.4995564Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2022-04-28T20:31:41.5011463Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2022-04-28T20:31:41.5027476Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2022-04-28T20:31:41.5043915Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2022-04-28T20:31:41.5059712Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2022-04-28T20:31:41.5075590Z ##[debug]Exporting function 'Invoke-API'.
2022-04-28T20:31:41.5091378Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2022-04-28T20:31:41.5107441Z ##[debug]Exporting function 'New-DatasetRefresh'.
2022-04-28T20:31:41.5123406Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2022-04-28T20:31:41.5139449Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2022-04-28T20:31:41.5155299Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2022-04-28T20:31:41.5171376Z ##[debug]Exporting function 'Get-PowerBIReport'.
2022-04-28T20:31:41.5187289Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2022-04-28T20:31:41.5203397Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2022-04-28T20:31:41.5219249Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2022-04-28T20:31:41.5235321Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2022-04-28T20:31:41.5251332Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2022-04-28T20:31:41.5267355Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2022-04-28T20:31:41.5283232Z ##[debug]Exporting function 'Import-PowerBIFile'.
2022-04-28T20:31:41.5304468Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2022-04-28T20:31:41.5320850Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2022-04-28T20:31:41.5336844Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2022-04-28T20:31:41.5352710Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2022-04-28T20:31:41.5368789Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2022-04-28T20:31:41.5384854Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2022-04-28T20:31:41.5400459Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2022-04-28T20:31:41.5416311Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2022-04-28T20:31:41.5432512Z ##[debug]Exporting function 'Set-Capacity'.
2022-04-28T20:31:41.5448177Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2022-04-28T20:31:41.5464233Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-28T20:31:41.5480808Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2022-04-28T20:31:41.5496690Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2022-04-28T20:31:41.5513858Z ##[debug]Exporting function 'Publish-TabularEditor'.
2022-04-28T20:31:41.5533880Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2022-04-28T20:31:41.5549926Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2022-04-28T20:31:41.5565639Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2022-04-28T20:31:41.5581750Z ##[debug]Importing function 'Get-PowerBICapacity'.
2022-04-28T20:31:41.5597812Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2022-04-28T20:31:41.5613558Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2022-04-28T20:31:41.5629605Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2022-04-28T20:31:41.5645193Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2022-04-28T20:31:41.5661305Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2022-04-28T20:31:41.5677110Z ##[debug]Importing function 'Get-PowerBIGateways'.
2022-04-28T20:31:41.5693208Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2022-04-28T20:31:41.5708961Z ##[debug]Importing function 'Get-PowerBiParameters'.
2022-04-28T20:31:41.5724859Z ##[debug]Importing function 'Get-PowerBIReport'.
2022-04-28T20:31:41.5754403Z ##[debug]Importing function 'Import-PowerBIFile'.
2022-04-28T20:31:41.5758690Z ##[debug]Importing function 'Invoke-API'.
2022-04-28T20:31:41.5775888Z ##[debug]Importing function 'New-DatasetRefresh'.
2022-04-28T20:31:41.5803080Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2022-04-28T20:31:41.5816159Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2022-04-28T20:31:41.5823724Z ##[debug]Importing function 'Publish-PowerBIFile'.
2022-04-28T20:31:41.5839790Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2022-04-28T20:31:41.5855587Z ##[debug]Importing function 'Publish-TabularEditor'.
2022-04-28T20:31:41.5871349Z ##[debug]Importing function 'Redo-PowerBIReport'.
2022-04-28T20:31:41.5887183Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2022-04-28T20:31:41.5902798Z ##[debug]Importing function 'Remove-PowerBIReport'.
2022-04-28T20:31:41.5919554Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2022-04-28T20:31:41.5935294Z ##[debug]Importing function 'Set-Capacity'.
2022-04-28T20:31:41.5951015Z ##[debug]Importing function 'Set-DatasetOwnership'.
2022-04-28T20:31:41.5967102Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2022-04-28T20:31:41.5982816Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2022-04-28T20:31:41.5998571Z ##[debug]Importing function 'Set-RefreshSchedule'.
2022-04-28T20:31:41.6014382Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2022-04-28T20:31:41.6030248Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2022-04-28T20:31:41.6045829Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2022-04-28T20:31:41.6061457Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2022-04-28T20:31:41.6077394Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2022-04-28T20:31:41.6093302Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2022-04-28T20:31:41.6109148Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2022-04-28T20:31:41.6125086Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2022-04-28T20:31:41.6359111Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '32419add-0de3-4b45-ab3c-107c7468c395'
2022-04-28T20:31:41.6481977Z ##[debug]ENDPOINT_URL_32419add-0de3-4b45-ab3c-107c7468c395: 'https://api.powerbi.com/v1.0/myorg'
2022-04-28T20:31:41.6507448Z ##[debug]ENDPOINT_AUTH_32419add-0de3-4b45-ab3c-107c7468c395: '****'
2022-04-28T20:31:41.6532734Z ##[debug]ENDPOINT_DATA_32419add-0de3-4b45-ab3c-107c7468c395: '{"OrganizationType":"Public"}'
2022-04-28T20:31:41.6605330Z ##[debug]{
2022-04-28T20:31:41.6617904Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg",
2022-04-28T20:31:41.6644403Z ##[debug] "Data": {
2022-04-28T20:31:41.6656314Z ##[debug] "OrganizationType": "Public"
2022-04-28T20:31:41.6668552Z ##[debug] },
2022-04-28T20:31:41.6680382Z ##[debug] "Auth": {
2022-04-28T20:31:41.6692046Z ##[debug] "parameters": {
2022-04-28T20:31:41.6703755Z ##[debug] "TenantId": "4febecd1-b635-4bb7-96fd-6688487e52f1",
2022-04-28T20:31:41.6716291Z ##[debug] "ClientId": "",
2022-04-28T20:31:41.6727871Z ##[debug] "ClientSecret": ,
2022-04-28T20:31:41.6739132Z ##[debug] "ClientCertificate": ""
2022-04-28T20:31:41.6750662Z ##[debug] },
2022-04-28T20:31:41.6763704Z ##[debug] "scheme": "None"
2022-04-28T20:31:41.6775500Z ##[debug] }
2022-04-28T20:31:41.6787558Z ##[debug]}
2022-04-28T20:31:42.3268303Z ##[debug]8:31:42 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2022-04-28T20:31:42.3291317Z ##[debug]8:31:42 PM - Cmdlet version: 1.2.1077.0
2022-04-28T20:31:42.3523153Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/4febecd1-b635-4bb7-96fd-6688487e52f1
2022-04-28T20:31:42.4227752Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42] Found 0 cache accounts and 0 broker accounts
2022-04-28T20:31:42.4279708Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(c945fe41-0c1e-4205-9137-5726655f56d8)
2022-04-28T20:31:42.4293282Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] === AcquireTokenForClientParameters ===
2022-04-28T20:31:42.4305263Z ##[debug]SendX5C: False
2022-04-28T20:31:42.4317519Z ##[debug]WithAzureRegion: False
2022-04-28T20:31:42.4328887Z ##[debug]RegionToUse:
2022-04-28T20:31:42.4340365Z ##[debug]ForceRefresh: False
2022-04-28T20:31:42.4402777Z ##[debug]
2022-04-28T20:31:42.4428060Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8]
2022-04-28T20:31:42.4440304Z ##[debug]=== Request Data ===
2022-04-28T20:31:42.4452713Z ##[debug]Authority Provided? - True
2022-04-28T20:31:42.4464787Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-28T20:31:42.4477474Z ##[debug]Extra Query Params Keys (space separated) -
2022-04-28T20:31:42.4488865Z ##[debug]ApiId - AcquireTokenForClient
2022-04-28T20:31:42.4500445Z ##[debug]IsConfidentialClient - True
2022-04-28T20:31:42.4511928Z ##[debug]SendX5C - False
2022-04-28T20:31:42.4523567Z ##[debug]LoginHint ? False
2022-04-28T20:31:42.4534574Z ##[debug]IsBrokerConfigured - False
2022-04-28T20:31:42.4546256Z ##[debug]HomeAccountId - False
2022-04-28T20:31:42.4558738Z ##[debug]CorrelationId - c945fe41-0c1e-4205-9137-5726655f56d8
2022-04-28T20:31:42.4578647Z ##[debug]
2022-04-28T20:31:42.4591174Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] === Token Acquisition (ClientCredentialRequest) started:
2022-04-28T20:31:42.4604053Z ##[debug]
2022-04-28T20:31:42.4667085Z ##[debug] Authority Host: login.microsoftonline.com
2022-04-28T20:31:42.5034485Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] Fetching instance discovery from the network from host login.microsoftonline.com.
2022-04-28T20:31:42.8305859Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] Resolving authority endpoints... Already resolved? - FALSE
2022-04-28T20:31:42.8325266Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] ScopeSet was missing from the token response, so using developer provided scopes in the result.
2022-04-28T20:31:42.8343518Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] Checking client info returned from the server..
2022-04-28T20:31:42.8361303Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] Saving Token Response to cache..
2022-04-28T20:31:42.8386541Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] ID Token not present in response.
2022-04-28T20:31:42.8429586Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] Saving AT in cache and removing overlapping ATs...
2022-04-28T20:31:42.8431447Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2022-04-28T20:31:42.8445374Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] Intersecting scope entries count - 0
2022-04-28T20:31:42.8501271Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:42 - c945fe41-0c1e-4205-9137-5726655f56d8] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/28/2022 21:31:41 +00:00 ===
2022-04-28T20:31:42.8517811Z ##[debug]8:31:42 PM - Connect-PowerBIServiceAccount end processing.
2022-04-28T20:31:42.8540452Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\s'
2022-04-28T20:31:42.8575592Z ##[debug]INPUT_WORKSPACENAME: 'PBI_Test_SPToWS'
2022-04-28T20:31:42.8611232Z ##[debug]INPUT_OVERWRITE: 'true'
2022-04-28T20:31:42.8620375Z ##[debug] Converted to bool: True
2022-04-28T20:31:42.8641901Z ##[debug]INPUT_CREATE: 'true'
2022-04-28T20:31:42.8658176Z ##[debug] Converted to bool: True
2022-04-28T20:31:42.8679778Z ##[debug]INPUT_ACTION: 'AddSP'
2022-04-28T20:31:42.8702370Z ##[debug]INPUT_DATASETNAME (empty)
2022-04-28T20:31:42.8744982Z ##[debug]INPUT_OLDURL (empty)
2022-04-28T20:31:42.8765890Z ##[debug]INPUT_NEWURL (empty)
2022-04-28T20:31:42.8790713Z ##[debug]INPUT_OLDSERVER (empty)
2022-04-28T20:31:42.8810353Z ##[debug]INPUT_NEWSERVER (empty)
2022-04-28T20:31:42.8867150Z ##[debug]INPUT_OLDDATABASE (empty)
2022-04-28T20:31:42.8918590Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2022-04-28T20:31:42.8935362Z ##[debug]INPUT_NEWDATABASE (empty)
2022-04-28T20:31:42.8956866Z ##[debug]INPUT_PERMISSION: 'Admin'
2022-04-28T20:31:42.8976975Z ##[debug]INPUT_USERS (empty)
2022-04-28T20:31:42.8997477Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2022-04-28T20:31:42.9018141Z ##[debug]INPUT_UPDATEALL: 'false'
2022-04-28T20:31:42.9033786Z ##[debug] Converted to bool: False
2022-04-28T20:31:42.9054146Z ##[debug]INPUT_SKIPREPORT: 'false'
2022-04-28T20:31:42.9069502Z ##[debug] Converted to bool: False
2022-04-28T20:31:42.9089273Z ##[debug]INPUT_INDIVIDUAL (empty)
2022-04-28T20:31:42.9109767Z ##[debug]INPUT_SERVICEPRINCIPALS: '74713fe1-f4a3-4b07-8118-3872373a59b5'
2022-04-28T20:31:42.9129486Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2022-04-28T20:31:42.9149026Z ##[debug]INPUT_PARAMETERINPUT (empty)
2022-04-28T20:31:42.9168824Z ##[debug]INPUT_GATEWAYNAME (empty)
2022-04-28T20:31:42.9188373Z ##[debug]INPUT_REPORTNAME (empty)
2022-04-28T20:31:42.9208420Z ##[debug]INPUT_CAPACITYNAME (empty)
2022-04-28T20:31:42.9228167Z ##[debug]INPUT_USERNAME (empty)
2022-04-28T20:31:42.9247828Z ##[debug]INPUT_PASSWORD (empty)
2022-04-28T20:31:42.9952146Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2022-04-28T20:31:42.9953858Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2022-04-28T20:31:42.9978558Z ##[debug] Converted to bool: False
2022-04-28T20:31:43.0000172Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2022-04-28T20:31:43.0017534Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2022-04-28T20:31:43.0042841Z ##[debug]WorkspaceName : PBI_Test_SPToWS
2022-04-28T20:31:43.0049077Z ##[debug]Create : True
2022-04-28T20:31:43.0064316Z ##[debug]Service principals : 74713fe1-f4a3-4b07-8118-3872373a59b5
2022-04-28T20:31:43.0070771Z Adding service principals to a Workspace
2022-04-28T20:31:43.0247652Z Getting Power BI Workspace properties; PBI_Test_SPToWS
2022-04-28T20:31:43.0318885Z ##[debug]8:31:43 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2022-04-28T20:31:43.0328859Z ##[debug]8:31:43 PM - Cmdlet version: 1.2.1077.0
2022-04-28T20:31:43.0428156Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43] Found 0 cache accounts and 0 broker accounts
2022-04-28T20:31:43.0499324Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 47e8e27b-d067-4e7d-a403-d1bb45816c87] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(47e8e27b-d067-4e7d-a403-d1bb45816c87)
2022-04-28T20:31:43.0513374Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 47e8e27b-d067-4e7d-a403-d1bb45816c87] === AcquireTokenForClientParameters ===
2022-04-28T20:31:43.0526989Z ##[debug]SendX5C: False
2022-04-28T20:31:43.0539749Z ##[debug]WithAzureRegion: False
2022-04-28T20:31:43.0551922Z ##[debug]RegionToUse:
2022-04-28T20:31:43.0564614Z ##[debug]ForceRefresh: False
2022-04-28T20:31:43.0585848Z ##[debug]
2022-04-28T20:31:43.0597966Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 47e8e27b-d067-4e7d-a403-d1bb45816c87]
2022-04-28T20:31:43.0610275Z ##[debug]=== Request Data ===
2022-04-28T20:31:43.0622315Z ##[debug]Authority Provided? - True
2022-04-28T20:31:43.0634400Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-28T20:31:43.0643751Z ##[debug]Extra Query Params Keys (space separated) -
2022-04-28T20:31:43.0649398Z ##[debug]ApiId - AcquireTokenForClient
2022-04-28T20:31:43.0660687Z ##[debug]IsConfidentialClient - True
2022-04-28T20:31:43.0671763Z ##[debug]SendX5C - False
2022-04-28T20:31:43.0682783Z ##[debug]LoginHint ? False
2022-04-28T20:31:43.0693822Z ##[debug]IsBrokerConfigured - False
2022-04-28T20:31:43.0704823Z ##[debug]HomeAccountId - False
2022-04-28T20:31:43.0715814Z ##[debug]CorrelationId - 47e8e27b-d067-4e7d-a403-d1bb45816c87
2022-04-28T20:31:43.0726764Z ##[debug]
2022-04-28T20:31:43.0744437Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 47e8e27b-d067-4e7d-a403-d1bb45816c87] === Token Acquisition (ClientCredentialRequest) started:
2022-04-28T20:31:43.0755154Z ##[debug]
2022-04-28T20:31:43.0766169Z ##[debug] Authority Host: login.microsoftonline.com
2022-04-28T20:31:43.0786996Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 47e8e27b-d067-4e7d-a403-d1bb45816c87] Access token is not expired. Returning the found cache entry. [Current time (04/28/2022 20:31:43) - Expiration Time (04/28/2022 21:31:41 +00:00) - Extended Expiration Time (04/28/2022 21:31:41 +00:00)]
2022-04-28T20:31:43.0805679Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 47e8e27b-d067-4e7d-a403-d1bb45816c87] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/28/2022 21:31:41 +00:00 ===
2022-04-28T20:31:43.2858971Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'pbi_test_sptows'&$top=100
2022-04-28T20:31:43.2863490Z ##[debug]Status Code: OK (200)
2022-04-28T20:31:43.2879927Z ##[debug]8:31:43 PM - Get-PowerBIWorkspace end processing.
2022-04-28T20:31:43.2951585Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]602f4d64-fa73-4e54-8153-c10e5c27c5b9
2022-04-28T20:31:43.3035182Z ##[debug]8:31:43 PM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2022-04-28T20:31:43.3052242Z ##[debug]8:31:43 PM - Cmdlet version: 1.2.1077.0
2022-04-28T20:31:43.3077319Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43] Found 0 cache accounts and 0 broker accounts
2022-04-28T20:31:43.3094126Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 4b0d79f6-55fb-495a-925c-0c1bfd42133a] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(4b0d79f6-55fb-495a-925c-0c1bfd42133a)
2022-04-28T20:31:43.3110089Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 4b0d79f6-55fb-495a-925c-0c1bfd42133a] === AcquireTokenForClientParameters ===
2022-04-28T20:31:43.3120979Z ##[debug]SendX5C: False
2022-04-28T20:31:43.3139629Z ##[debug]WithAzureRegion: False
2022-04-28T20:31:43.3149803Z ##[debug]RegionToUse:
2022-04-28T20:31:43.3152938Z ##[debug]ForceRefresh: False
2022-04-28T20:31:43.3164110Z ##[debug]
2022-04-28T20:31:43.3181239Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 4b0d79f6-55fb-495a-925c-0c1bfd42133a]
2022-04-28T20:31:43.3192184Z ##[debug]=== Request Data ===
2022-04-28T20:31:43.3203351Z ##[debug]Authority Provided? - True
2022-04-28T20:31:43.3214582Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2022-04-28T20:31:43.3225670Z ##[debug]Extra Query Params Keys (space separated) -
2022-04-28T20:31:43.3236776Z ##[debug]ApiId - AcquireTokenForClient
2022-04-28T20:31:43.3247725Z ##[debug]IsConfidentialClient - True
2022-04-28T20:31:43.3258922Z ##[debug]SendX5C - False
2022-04-28T20:31:43.3269943Z ##[debug]LoginHint ? False
2022-04-28T20:31:43.3280934Z ##[debug]IsBrokerConfigured - False
2022-04-28T20:31:43.3291895Z ##[debug]HomeAccountId - False
2022-04-28T20:31:43.3302919Z ##[debug]CorrelationId - 4b0d79f6-55fb-495a-925c-0c1bfd42133a
2022-04-28T20:31:43.3313820Z ##[debug]
2022-04-28T20:31:43.3330371Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 4b0d79f6-55fb-495a-925c-0c1bfd42133a] === Token Acquisition (ClientCredentialRequest) started:
2022-04-28T20:31:43.3339750Z ##[debug]
2022-04-28T20:31:43.3350943Z ##[debug] Authority Host: login.microsoftonline.com
2022-04-28T20:31:43.3368326Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 4b0d79f6-55fb-495a-925c-0c1bfd42133a] Access token is not expired. Returning the found cache entry. [Current time (04/28/2022 20:31:43) - Expiration Time (04/28/2022 21:31:41 +00:00) - Extended Expiration Time (04/28/2022 21:31:41 +00:00)]
2022-04-28T20:31:43.3384047Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 20:31:43 - 4b0d79f6-55fb-495a-925c-0c1bfd42133a] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/28/2022 21:31:41 +00:00 ===
2022-04-28T20:31:43.3401099Z ##[debug]8:31:43 PM - Get-PowerBIAccessToken end processing.
2022-04-28T20:31:43.3427938Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/602f4d64-fa73-4e54-8153-c10e5c27c5b9/users
2022-04-28T20:31:43.4071169Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/602f4d64-fa73-4e54-8153-c10e5c27c5b9/users with -1-byte payload
2022-04-28T20:31:43.9039764Z Done processing Power BI Actions
2022-04-28T20:31:43.9678450Z ##[debug]Caught exception from task script.
2022-04-28T20:31:43.9711923Z ##[debug]Error record:
2022-04-28T20:31:44.0338347Z ##[debug]Invoke-API : InvalidRequest
2022-04-28T20:31:44.0350711Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1:754 char:9
2022-04-28T20:31:44.0362333Z ##[debug]+ Invoke-API -Url $url -Method "Post" -Body $body -ContentType ...
2022-04-28T20:31:44.0373405Z ##[debug]+ ~~~~~~~~~~~~~
2022-04-28T20:31:44.0398713Z ##[debug] + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
2022-04-28T20:31:44.0401815Z ##[debug] + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-API
2022-04-28T20:31:44.0412973Z ##[debug]
2022-04-28T20:31:44.0431169Z ##[debug]Script stack trace:
2022-04-28T20:31:44.0471684Z ##[debug]at Invoke-API, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 307
2022-04-28T20:31:44.0487632Z ##[debug]at Add-PowerBIWorkspaceSP, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 754
2022-04-28T20:31:44.0499292Z ##[debug]at
NV2601
commented
2 years ago Can you please advise on the issue above. I attached the complete logs too
NV2601
commented
2 years ago Even when i tried calling through REST Api. It gives me this error.
2022-05-03T13:48:44.4060744Z ##[debug]Error record:
2022-05-03T13:48:44.5115719Z ##[debug]Invoke-PowerBIRestMethod : One or more errors occurred.
2022-05-03T13:48:44.5151784Z ##[debug]At D:\a_temp\63703b9b-beba-4edd-9ec5-35fe50347715.ps1:76 char:1
2022-05-03T13:48:44.5267954Z ##[debug]+ Invoke-PowerBIRestMethod -Url $url2 -Method POST -ContentType "applic ...
2022-05-03T13:48:44.5303314Z ##[debug]+ ~~~~~~~~~~~~~~~~~
2022-05-03T13:48:44.5338572Z ##[debug] + CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIR estMethod], AggregateException
2022-05-03T13:48:44.5401730Z ##[debug] + FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
2022-05-03T13:48:44.5437476Z ##[debug]
2022-05-03T13:48:44.5548193Z ##[debug]Script stack trace:
2022-05-03T13:48:44.5716259Z ##[debug]at
NV2601
commented
2 years ago Can you please advise on the issue above. I attached the complete logs too ???
maikvandergaag
commented
2 years ago What ID did you use for adding? It should be the Object ID
NV2601
commented
2 years ago yes i have used Object ID only. Do i need to set any API permissions in Azure anywhere ?
maikvandergaag
commented
2 years ago Of the enterprise application or the regular application?
NV2601
commented
2 years ago I meant since we are calling Power BI API through Azure through this extension tool so is there needs to some permissions i should setup ?
maikvandergaag
commented
2 years ago Yes you need to setup the API permissions depending on the tasks you would like to do.
Issue: I am trying to use Add service Principal to Workspace from Power BI Actions extension in my Tasks in my Azure pipeline but its failing
2022-04-28T18:52:35.2617622Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 18:52:35 - 459f649e-9307-4845-bdc4-bb94383375f7] === Token Acquisition (ClientCredentialRequest) started: 2022-04-28T18:52:35.2651034Z ##[debug], D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\run.ps1: line 132
2022-04-28T18:52:36.1653909Z ##[debug]at , : line 1
2022-04-28T18:52:36.1666272Z ##[debug]at , : line 22
2022-04-28T18:52:36.1681600Z ##[debug]at , : line 18
2022-04-28T18:52:36.1716046Z ##[debug]at , : line 1
2022-04-28T18:52:36.1747285Z ##[debug]Exception:
2022-04-28T18:52:36.1901101Z ##[debug]Microsoft.PowerShell.Commands.WriteErrorException: InvalidRequest
2022-04-28T18:52:36.2153035Z ##[error]InvalidRequest
2022-04-28T18:52:36.2163517Z ##[debug]Processed: ##vso[task.logissue type=error]InvalidRequest
2022-04-28T18:52:36.2173652Z ##[debug]Processed: ##vso[task.complete result=Failed]
2022-04-28T18:52:36.2465219Z ##[section]Finishing: Power BI Action: AddSP
2022-04-28T18:52:35.2654671Z ##[debug] Authority Host: login.microsoftonline.com 2022-04-28T18:52:35.2663395Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 18:52:35 - 459f649e-9307-4845-bdc4-bb94383375f7] Access token is not expired. Returning the found cache entry. [Current time (04/28/2022 18:52:35) - Expiration Time (04/28/2022 19:52:33 +00:00) - Extended Expiration Time (04/28/2022 19:52:33 +00:00)] 2022-04-28T18:52:35.2706302Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.17763.0 [04/28/2022 18:52:35 - 459f649e-9307-4845-bdc4-bb94383375f7] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 04/28/2022 19:52:33 +00:00 === 2022-04-28T18:52:35.2723675Z ##[debug]6:52:35 PM - Get-PowerBIAccessToken end processing. 2022-04-28T18:52:35.2796614Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/602f4d64-fa73-4e54-8153-c10e5c27c5b9/users 2022-04-28T18:52:35.2880245Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/602f4d64-fa73-4e54-8153-c10e5c27c5b9/users with -1-byte payload 2022-04-28T18:52:35.9740465Z Done processing Power BI Actions 2022-04-28T18:52:36.0483411Z ##[debug]Caught exception from task script. 2022-04-28T18:52:36.0499847Z ##[debug]Error record: 2022-04-28T18:52:36.1441463Z ##[debug]Invoke-API : InvalidRequest 2022-04-28T18:52:36.1455205Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1:754 char:9 2022-04-28T18:52:36.1478162Z ##[debug]+ Invoke-API -Url $url -Method "Post" -Body $body -ContentType ... 2022-04-28T18:52:36.1491836Z ##[debug]+
~~~~~~~~~~~~~ 2022-04-28T18:52:36.1505902Z ##[debug] + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException 2022-04-28T18:52:36.1516748Z ##[debug] + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Invoke-API 2022-04-28T18:52:36.1552620Z ##[debug] 2022-04-28T18:52:36.1596037Z ##[debug]Script stack trace: 2022-04-28T18:52:36.1604992Z ##[debug]at Invoke-API, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 307 2022-04-28T18:52:36.1634483Z ##[debug]at Add-PowerBIWorkspaceSP, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.31\ps_modules\PowerBI\PowerBI.psm1: line 754 2022-04-28T18:52:36.1648648Z ##[debug]at