maikvandergaag / msft-extensions

Repository for extensions mainly used for Azure DevOps Extensions
https://msftplayground.com
MIT License
126 stars 81 forks source link

Upload Power BI report: Skip report uploading? Overwrite error #479

Closed DEvangelisti closed 12 months ago

DEvangelisti commented 1 year ago

Describe the issue The "Upload Power BI report" tool when using "Skip report uploading?" option does not overwrite the dataset if present.

Extension

To Reproduce Steps to reproduce the behavior:

  1. Deploy a dataset without a report
  2. Deploy the same dataset again

Expected behavior The dataset should be overwrited

Situation (please complete the following information):

Log info Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/xxxxxxxx/imports?datasetDisplayName=DASHBOARD_ABBANDONI_TEST_3.pbix&nameConflict=Abort&skipReport=True 2023-03-21T16:24:22.9932180Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/xxxxxxxx/imports?datasetDisplayName=DASHBOARD_ABBANDONI_TEST_3.pbix&nameConflict=Abort&skipReport=True with -1-byte payload ... The remote server returned an error: (400) Bad Request.

Additional information In azuredevops\powerbiactions-new\powerbiactionsnew\ps_modules\PowerBi\powerbi.psm1 line 846 it checks if the report exists. But only the dataset exists and not the report so $nameConflict = "Abort" and the request does no succede.

maikvandergaag commented 1 year ago

@DEvangelisti could you share the log file? in debug mode?

DEvangelisti commented 1 year ago
2023-03-21T16:24:18.1056981Z ##[debug]Evaluating condition for step: 'Publish Dashboard copy'
2023-03-21T16:24:18.1063874Z ##[debug]Evaluating: succeeded()
2023-03-21T16:24:18.1064423Z ##[debug]Evaluating succeeded:
2023-03-21T16:24:18.1065607Z ##[debug]=> True
2023-03-21T16:24:18.1071172Z ##[debug]Result: True
2023-03-21T16:24:18.1105394Z ##[section]Starting: Publish Dashboard copy
2023-03-21T16:24:18.1762099Z ==============================================================================
2023-03-21T16:24:18.1762329Z Task         : Power BI Actions
2023-03-21T16:24:18.1762460Z Description  : Release Task Power BI Actions
2023-03-21T16:24:18.1762608Z Version      : 5.4.39
2023-03-21T16:24:18.1762726Z Author       : Maik van der Gaag
2023-03-21T16:24:18.1762858Z Help         : 
2023-03-21T16:24:18.1762946Z ==============================================================================
2023-03-21T16:24:19.2067084Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2023-03-21T16:24:19.3511752Z Starting Power BI Actions extension
2023-03-21T16:24:19.3661297Z ##[debug]Entering D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1.
2023-03-21T16:24:19.3729421Z ### Required Module is needed. Importing now...
2023-03-21T16:24:19.3773225Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2023-03-21T16:24:19.3850641Z ##[debug]Loading 'TypesToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2023-03-21T16:24:19.3881508Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2023-03-21T16:24:19.4312721Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2023-03-21T16:24:19.4372119Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2023-03-21T16:24:19.4545919Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2023-03-21T16:24:19.4569214Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2023-03-21T16:24:19.4605004Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2023-03-21T16:24:19.4624157Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2023-03-21T16:24:19.4645164Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2023-03-21T16:24:19.4671835Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2023-03-21T16:24:19.4691655Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2023-03-21T16:24:19.4712142Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2023-03-21T16:24:19.4763736Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2023-03-21T16:24:19.4784721Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2023-03-21T16:24:19.4805753Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2023-03-21T16:24:19.4827058Z ##[debug]Importing alias 'Login-PowerBI'.
2023-03-21T16:24:19.4847091Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2023-03-21T16:24:19.4885817Z ##[debug]Importing alias 'Logout-PowerBI'.
2023-03-21T16:24:19.4920340Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2023-03-21T16:24:19.4941592Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2023-03-21T16:24:19.4982822Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2023-03-21T16:24:19.5022389Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2023-03-21T16:24:19.5106524Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2023-03-21T16:24:19.5354882Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2023-03-21T16:24:19.5390033Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2023-03-21T16:24:19.5512089Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2023-03-21T16:24:19.5560461Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2023-03-21T16:24:19.5565280Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2023-03-21T16:24:19.5607698Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2023-03-21T16:24:19.6318193Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2023-03-21T16:24:19.6347201Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2023-03-21T16:24:19.6372091Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2023-03-21T16:24:19.6391538Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2023-03-21T16:24:19.6430282Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2023-03-21T16:24:19.6451630Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2023-03-21T16:24:19.6462638Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2023-03-21T16:24:19.6488202Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2023-03-21T16:24:19.6508757Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2023-03-21T16:24:19.6528514Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2023-03-21T16:24:19.6546789Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2023-03-21T16:24:19.6564434Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2023-03-21T16:24:19.6583306Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2023-03-21T16:24:19.6601533Z ##[debug]Importing alias 'New-PowerBIGroup'.
2023-03-21T16:24:19.6620262Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2023-03-21T16:24:19.6649430Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2023-03-21T16:24:19.6685152Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2023-03-21T16:24:19.6713378Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2023-03-21T16:24:19.6798014Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2023-03-21T16:24:19.6841781Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2023-03-21T16:24:19.6889270Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2023-03-21T16:24:19.6943571Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2023-03-21T16:24:19.6964617Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2023-03-21T16:24:19.6984167Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2023-03-21T16:24:19.7005057Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2023-03-21T16:24:19.7027038Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2023-03-21T16:24:19.7049603Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2023-03-21T16:24:19.7070031Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2023-03-21T16:24:19.7099344Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2023-03-21T16:24:19.7111225Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2023-03-21T16:24:19.7130751Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2023-03-21T16:24:19.7149512Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2023-03-21T16:24:19.7168965Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2023-03-21T16:24:19.7187638Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2023-03-21T16:24:19.7204497Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2023-03-21T16:24:19.7296006Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2023-03-21T16:24:19.7317219Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2023-03-21T16:24:19.7336472Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2023-03-21T16:24:19.7354632Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2023-03-21T16:24:19.7401029Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2023-03-21T16:24:19.7419332Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2023-03-21T16:24:19.7452824Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2023-03-21T16:24:19.7516542Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2023-03-21T16:24:19.7801601Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2023-03-21T16:24:19.7846749Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2023-03-21T16:24:19.7902693Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2023-03-21T16:24:19.7925785Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2023-03-21T16:24:19.7948589Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2023-03-21T16:24:19.7969780Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2023-03-21T16:24:19.7990123Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2023-03-21T16:24:19.8009909Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2023-03-21T16:24:19.8029706Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2023-03-21T16:24:19.8050697Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2023-03-21T16:24:19.8068988Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2023-03-21T16:24:19.8087610Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2023-03-21T16:24:19.8812840Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2023-03-21T16:24:19.8831528Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2023-03-21T16:24:19.8853203Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2023-03-21T16:24:19.8873308Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2023-03-21T16:24:19.8931324Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2023-03-21T16:24:19.8983842Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2023-03-21T16:24:19.9003530Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2023-03-21T16:24:19.9022339Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2023-03-21T16:24:19.9040759Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2023-03-21T16:24:19.9086141Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2023-03-21T16:24:19.9104722Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2023-03-21T16:24:19.9124000Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2023-03-21T16:24:19.9142236Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2023-03-21T16:24:19.9186146Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2023-03-21T16:24:19.9205250Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2023-03-21T16:24:19.9221819Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2023-03-21T16:24:19.9273185Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2023-03-21T16:24:19.9292109Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2023-03-21T16:24:19.9308616Z ### Trying to import the incorporated module for PowerBI
2023-03-21T16:24:19.9387836Z ##[debug]Loading module from path 'D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1'.
2023-03-21T16:24:19.9915081Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2023-03-21T16:24:19.9936095Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2023-03-21T16:24:19.9954166Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2023-03-21T16:24:19.9974996Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2023-03-21T16:24:19.9995986Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2023-03-21T16:24:20.0018003Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2023-03-21T16:24:20.0037271Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2023-03-21T16:24:20.0057914Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2023-03-21T16:24:20.0076305Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2023-03-21T16:24:20.0117982Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2023-03-21T16:24:20.0135893Z ##[debug]Exporting function 'Invoke-API'.
2023-03-21T16:24:20.0154665Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2023-03-21T16:24:20.0172804Z ##[debug]Exporting function 'New-DatasetRefresh'.
2023-03-21T16:24:20.0191630Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2023-03-21T16:24:20.0209812Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2023-03-21T16:24:20.0228620Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2023-03-21T16:24:20.0246080Z ##[debug]Exporting function 'Get-PowerBIReport'.
2023-03-21T16:24:20.0265334Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2023-03-21T16:24:20.0284368Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2023-03-21T16:24:20.0303477Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2023-03-21T16:24:20.0322015Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2023-03-21T16:24:20.0340215Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2023-03-21T16:24:20.0358370Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2023-03-21T16:24:20.0398483Z ##[debug]Exporting function 'Import-PowerBIFile'.
2023-03-21T16:24:20.0416522Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2023-03-21T16:24:20.0435034Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2023-03-21T16:24:20.0481168Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2023-03-21T16:24:20.0500946Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2023-03-21T16:24:20.0519015Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2023-03-21T16:24:20.0560183Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2023-03-21T16:24:20.0577569Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2023-03-21T16:24:20.0594956Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2023-03-21T16:24:20.0612733Z ##[debug]Exporting function 'Set-Capacity'.
2023-03-21T16:24:20.0630771Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2023-03-21T16:24:20.0649224Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2023-03-21T16:24:20.0668519Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2023-03-21T16:24:20.0689472Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2023-03-21T16:24:20.0708227Z ##[debug]Exporting function 'Publish-TabularEditor'.
2023-03-21T16:24:20.0746939Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'.
2023-03-21T16:24:20.0794000Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'.
2023-03-21T16:24:20.0815403Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'.
2023-03-21T16:24:20.0861235Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2023-03-21T16:24:20.0884005Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2023-03-21T16:24:20.0931416Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2023-03-21T16:24:20.0950424Z ##[debug]Importing function 'Get-PowerBICapacity'.
2023-03-21T16:24:20.0995482Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2023-03-21T16:24:20.1002712Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2023-03-21T16:24:20.1029132Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2023-03-21T16:24:20.1047654Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2023-03-21T16:24:20.1067230Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'.
2023-03-21T16:24:20.1087214Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2023-03-21T16:24:20.1127962Z ##[debug]Importing function 'Get-PowerBIGateways'.
2023-03-21T16:24:20.1146734Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2023-03-21T16:24:20.1191009Z ##[debug]Importing function 'Get-PowerBiParameters'.
2023-03-21T16:24:20.1209438Z ##[debug]Importing function 'Get-PowerBIReport'.
2023-03-21T16:24:20.1231352Z ##[debug]Importing function 'Import-PowerBIFile'.
2023-03-21T16:24:20.1275260Z ##[debug]Importing function 'Invoke-API'.
2023-03-21T16:24:20.1297871Z ##[debug]Importing function 'New-DatasetRefresh'.
2023-03-21T16:24:20.1317472Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2023-03-21T16:24:20.1365546Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2023-03-21T16:24:20.1366723Z ##[debug]Importing function 'Publish-PowerBIFile'.
2023-03-21T16:24:20.1373000Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2023-03-21T16:24:20.1391927Z ##[debug]Importing function 'Publish-TabularEditor'.
2023-03-21T16:24:20.1411360Z ##[debug]Importing function 'Redo-PowerBIReport'.
2023-03-21T16:24:20.1457168Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2023-03-21T16:24:20.1498005Z ##[debug]Importing function 'Remove-PowerBIReport'.
2023-03-21T16:24:20.1516216Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2023-03-21T16:24:20.1535523Z ##[debug]Importing function 'Set-Capacity'.
2023-03-21T16:24:20.1553046Z ##[debug]Importing function 'Set-DatasetOwnership'.
2023-03-21T16:24:20.1572994Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2023-03-21T16:24:20.1621175Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2023-03-21T16:24:20.1640672Z ##[debug]Importing function 'Set-RefreshSchedule'.
2023-03-21T16:24:20.1660848Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2023-03-21T16:24:20.1708034Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2023-03-21T16:24:20.1729184Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2023-03-21T16:24:20.1748122Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2023-03-21T16:24:20.1794793Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2023-03-21T16:24:20.1837016Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2023-03-21T16:24:20.1884170Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2023-03-21T16:24:20.1903302Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2023-03-21T16:24:20.2340379Z ##[debug]INPUT_POWERBISERVICEENDPOINT: 'xxxxxxx-9c1c-402f-bfb9-0f3a91c7e25a'
2023-03-21T16:24:20.2481897Z ##[debug]ENDPOINT_URL_xxxxxxx-9c1c-402f-bfb9-0f3a91c7e25a: 'https://api.powerbi.com/v1.0/myorg'
2023-03-21T16:24:20.2508152Z ##[debug]ENDPOINT_AUTH_xxxxxxx-9c1c-402f-bfb9-0f3a91c7e25a: '********'
2023-03-21T16:24:20.2535144Z ##[debug]ENDPOINT_DATA_xxxxxxx-9c1c-402f-bfb9-0f3a91c7e25a: '{"OrganizationType":"Public"}'
2023-03-21T16:24:20.2680105Z ##[debug]{
2023-03-21T16:24:20.2722359Z ##[debug]    "Url":  "https://api.powerbi.com/v1.0/myorg",
2023-03-21T16:24:20.2736868Z ##[debug]    "Data":  {
2023-03-21T16:24:20.2752117Z ##[debug]                 "OrganizationType":  "Public"
2023-03-21T16:24:20.2773357Z ##[debug]             },
2023-03-21T16:24:20.2883893Z ##[debug]    "Auth":  {
2023-03-21T16:24:20.2899864Z ##[debug]                 "parameters":  {
2023-03-21T16:24:20.2946379Z ##[debug]                                    "TenantId":  "c000000-84a0-43af-bd29-a7892e94b5b7",
2023-03-21T16:24:20.2962464Z ##[debug]                                    "ClientId":  "***",
2023-03-21T16:24:20.2978298Z ##[debug]                                    "ClientSecret":  ***,
2023-03-21T16:24:20.2993577Z ##[debug]                                    "ClientCertificate":  ""
2023-03-21T16:24:20.3008100Z ##[debug]                                },
2023-03-21T16:24:20.3051000Z ##[debug]                 "scheme":  "None"
2023-03-21T16:24:20.3078239Z ##[debug]             }
2023-03-21T16:24:20.3092999Z ##[debug]}
2023-03-21T16:24:20.5859288Z ##[debug]4:24:20 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2023-03-21T16:24:20.5887994Z ##[debug]4:24:20 PM - Cmdlet version: 1.2.1077.0
2023-03-21T16:24:20.6344763Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/c000000-84a0-43af-bd29-a7892e94b5b7
2023-03-21T16:24:20.7552138Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:20] Found 0 cache accounts and 0 broker accounts
2023-03-21T16:24:20.7619838Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:20 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979)
2023-03-21T16:24:20.7652319Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:20 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] === AcquireTokenForClientParameters ===
2023-03-21T16:24:20.7666132Z ##[debug]SendX5C: False
2023-03-21T16:24:20.7680808Z ##[debug]WithAzureRegion: False
2023-03-21T16:24:20.7695112Z ##[debug]RegionToUse: 
2023-03-21T16:24:20.7708939Z ##[debug]ForceRefresh: False
2023-03-21T16:24:20.7722331Z ##[debug]
2023-03-21T16:24:20.7846353Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:20 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] 
2023-03-21T16:24:20.7876885Z ##[debug]=== Request Data ===
2023-03-21T16:24:20.7905667Z ##[debug]Authority Provided? - True
2023-03-21T16:24:20.7919588Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2023-03-21T16:24:20.7933496Z ##[debug]Extra Query Params Keys (space separated) - 
2023-03-21T16:24:20.7946908Z ##[debug]ApiId - AcquireTokenForClient
2023-03-21T16:24:20.8017123Z ##[debug]IsConfidentialClient - True
2023-03-21T16:24:20.8032412Z ##[debug]SendX5C - False
2023-03-21T16:24:20.8047447Z ##[debug]LoginHint ? False
2023-03-21T16:24:20.8089358Z ##[debug]IsBrokerConfigured - False
2023-03-21T16:24:20.8104391Z ##[debug]HomeAccountId - False
2023-03-21T16:24:20.8152035Z ##[debug]CorrelationId - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979
2023-03-21T16:24:20.8169505Z ##[debug]
2023-03-21T16:24:20.8201623Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:20 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] === Token Acquisition (ClientCredentialRequest) started:
2023-03-21T16:24:20.8241586Z ##[debug]  
2023-03-21T16:24:20.8255505Z ##[debug]  Authority Host: login.microsoftonline.com
2023-03-21T16:24:20.8587105Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:20 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] Fetching instance discovery from the network from host login.microsoftonline.com. 
2023-03-21T16:24:21.3782257Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] Resolving authority endpoints... Already resolved? - FALSE
2023-03-21T16:24:21.3802681Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] ScopeSet was missing from the token response, so using developer provided scopes in the result. 
2023-03-21T16:24:21.3821194Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] Checking client info returned from the server..
2023-03-21T16:24:21.3839277Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] Saving Token Response to cache..
2023-03-21T16:24:21.3884356Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] ID Token not present in response. 
2023-03-21T16:24:21.3902251Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] Saving AT in cache and removing overlapping ATs...
2023-03-21T16:24:21.3920836Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2023-03-21T16:24:21.3939163Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] Intersecting scope entries count - 0
2023-03-21T16:24:21.3983339Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-57aa-49f6-b4b7-b1ec8f498979] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 03/21/2023 17:24:20 +00:00 ===
2023-03-21T16:24:21.4003912Z ##[debug]4:24:21 PM - Connect-PowerBIServiceAccount end processing.
2023-03-21T16:24:21.4025825Z ##[debug]INPUT_POWERBIPATH: 'D:\a\r1\a\_powerbi-release-tests\powerbi\TEST\DASHBOARD_ABBANDONI_TEST_3.pbix'
2023-03-21T16:24:21.4047491Z ##[debug]INPUT_WORKSPACENAME: 'DE_TEST_WS'
2023-03-21T16:24:21.4068632Z ##[debug]INPUT_OVERWRITE: 'true'
2023-03-21T16:24:21.4104565Z ##[debug] Converted to bool: False
2023-03-21T16:24:21.4128639Z ##[debug]INPUT_CREATE: 'true'
2023-03-21T16:24:21.4173943Z ##[debug] Converted to bool: True
2023-03-21T16:24:21.4223972Z ##[debug]INPUT_ACTION: 'Publish'
2023-03-21T16:24:21.4249410Z ##[debug]INPUT_DATASETNAME (empty)
2023-03-21T16:24:21.4293077Z ##[debug]INPUT_OLDURL (empty)
2023-03-21T16:24:21.4319352Z ##[debug]INPUT_NEWURL (empty)
2023-03-21T16:24:21.4343850Z ##[debug]INPUT_OLDSERVER (empty)
2023-03-21T16:24:21.4374841Z ##[debug]INPUT_NEWSERVER (empty)
2023-03-21T16:24:21.4397676Z ##[debug]INPUT_OLDDATABASE (empty)
2023-03-21T16:24:21.4420887Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2023-03-21T16:24:21.4478136Z ##[debug]INPUT_NEWDATABASE (empty)
2023-03-21T16:24:21.4503709Z ##[debug]INPUT_PERMISSION (empty)
2023-03-21T16:24:21.4527137Z ##[debug]INPUT_USERS (empty)
2023-03-21T16:24:21.4571835Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2023-03-21T16:24:21.4596662Z ##[debug]INPUT_UPDATEALL: 'false'
2023-03-21T16:24:21.4615594Z ##[debug] Converted to bool: False
2023-03-21T16:24:21.4638680Z ##[debug]INPUT_SKIPREPORT: 'true'
2023-03-21T16:24:21.4656729Z ##[debug] Converted to bool: True
2023-03-21T16:24:21.4682340Z ##[debug]INPUT_INDIVIDUAL (empty)
2023-03-21T16:24:21.4708953Z ##[debug]INPUT_SERVICEPRINCIPALS (empty)
2023-03-21T16:24:21.4731546Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2023-03-21T16:24:21.4754938Z ##[debug]INPUT_PARAMETERINPUT (empty)
2023-03-21T16:24:21.4777572Z ##[debug]INPUT_GATEWAYNAME (empty)
2023-03-21T16:24:21.4799130Z ##[debug]INPUT_REPORTNAME (empty)
2023-03-21T16:24:21.4822137Z ##[debug]INPUT_CAPACITYNAME (empty)
2023-03-21T16:24:21.4876106Z ##[debug]INPUT_USERNAME (empty)
2023-03-21T16:24:21.4899102Z ##[debug]INPUT_PASSWORD (empty)
2023-03-21T16:24:21.4926528Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2023-03-21T16:24:21.5197788Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2023-03-21T16:24:21.5228341Z ##[debug] Converted to bool: False
2023-03-21T16:24:21.5257982Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2023-03-21T16:24:21.5606085Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2023-03-21T16:24:21.5640853Z ##[debug]INPUT_PRINCIPALTYPE: 'User'
2023-03-21T16:24:21.5647183Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty)
2023-03-21T16:24:21.5681113Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty)
2023-03-21T16:24:21.5711442Z ##[debug]INPUT_DATASETACCESSRIGHT (empty)
2023-03-21T16:24:21.5752388Z ##[debug]WorkspaceName         : DE_TEST_WS
2023-03-21T16:24:21.5775480Z ##[debug]Create                : True
2023-03-21T16:24:21.5798496Z ##[debug]File patern             : D:\a\r1\a\_powerbi-release-tests\powerbi\TEST\DASHBOARD_ABBANDONI_TEST_3.pbix
2023-03-21T16:24:21.5825122Z ##[debug]Remove report           : True
2023-03-21T16:24:21.6067167Z Getting Power BI Workspace properties; DE_TEST_WS
2023-03-21T16:24:21.6148782Z ##[debug]4:24:21 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2023-03-21T16:24:21.6150041Z ##[debug]4:24:21 PM - Cmdlet version: 1.2.1077.0
2023-03-21T16:24:21.6377814Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21] Found 0 cache accounts and 0 broker accounts
2023-03-21T16:24:21.6397971Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-7ab6-4383-b641-812edf83c7e9] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(xxxxxxxx-7ab6-4383-b641-812edf83c7e9)
2023-03-21T16:24:21.6416489Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-7ab6-4383-b641-812edf83c7e9] === AcquireTokenForClientParameters ===
2023-03-21T16:24:21.6457611Z ##[debug]SendX5C: False
2023-03-21T16:24:21.6470878Z ##[debug]WithAzureRegion: False
2023-03-21T16:24:21.6483898Z ##[debug]RegionToUse: 
2023-03-21T16:24:21.6496995Z ##[debug]ForceRefresh: False
2023-03-21T16:24:21.6509682Z ##[debug]
2023-03-21T16:24:21.6557289Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-7ab6-4383-b641-812edf83c7e9] 
2023-03-21T16:24:21.6571954Z ##[debug]=== Request Data ===
2023-03-21T16:24:21.6585213Z ##[debug]Authority Provided? - True
2023-03-21T16:24:21.6655540Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2023-03-21T16:24:21.6697347Z ##[debug]Extra Query Params Keys (space separated) - 
2023-03-21T16:24:21.6712187Z ##[debug]ApiId - AcquireTokenForClient
2023-03-21T16:24:21.6731693Z ##[debug]IsConfidentialClient - True
2023-03-21T16:24:21.6746920Z ##[debug]SendX5C - False
2023-03-21T16:24:21.6765043Z ##[debug]LoginHint ? False
2023-03-21T16:24:21.6780639Z ##[debug]IsBrokerConfigured - False
2023-03-21T16:24:21.6795617Z ##[debug]HomeAccountId - False
2023-03-21T16:24:21.6810500Z ##[debug]CorrelationId - xxxxxxxx-7ab6-4383-b641-812edf83c7e9
2023-03-21T16:24:21.6826627Z ##[debug]
2023-03-21T16:24:21.6847095Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-7ab6-4383-b641-812edf83c7e9] === Token Acquisition (ClientCredentialRequest) started:
2023-03-21T16:24:21.6861993Z ##[debug]  
2023-03-21T16:24:21.6876340Z ##[debug]  Authority Host: login.microsoftonline.com
2023-03-21T16:24:21.6956184Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-7ab6-4383-b641-812edf83c7e9] Access token is not expired. Returning the found cache entry. [Current time (03/21/2023 16:24:21) - Expiration Time (03/21/2023 17:24:20 +00:00) - Extended Expiration Time (03/21/2023 17:24:20 +00:00)]
2023-03-21T16:24:21.6984946Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:21 - xxxxxxxx-7ab6-4383-b641-812edf83c7e9] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 03/21/2023 17:24:20 +00:00 ===
2023-03-21T16:24:22.3180356Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'de_test_ws'&$top=100
2023-03-21T16:24:22.3195430Z ##[debug]Status Code: OK (200)
2023-03-21T16:24:22.3215160Z ##[debug]4:24:22 PM - Get-PowerBIWorkspace end processing.
2023-03-21T16:24:22.3283925Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]xxxxxxx-d341-466f-895f-2ef33808bc8c
2023-03-21T16:24:22.3382452Z Trying to publish PowerBI File: D:\a\r1\a\_powerbi-release-tests\powerbi\TEST\DASHBOARD_ABBANDONI_TEST_3.pbix
2023-03-21T16:24:22.3426725Z Checking for existing Reports with the name: DASHBOARD_ABBANDONI_TEST_3
2023-03-21T16:24:22.3525809Z ##[debug]4:24:22 PM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2023-03-21T16:24:22.3565516Z ##[debug]4:24:22 PM - Cmdlet version: 1.2.1077.0
2023-03-21T16:24:22.3594271Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22] Found 0 cache accounts and 0 broker accounts
2023-03-21T16:24:22.3642060Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2)
2023-03-21T16:24:22.3661672Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2] === AcquireTokenForClientParameters ===
2023-03-21T16:24:22.3676721Z ##[debug]SendX5C: False
2023-03-21T16:24:22.3692439Z ##[debug]WithAzureRegion: False
2023-03-21T16:24:22.3709599Z ##[debug]RegionToUse: 
2023-03-21T16:24:22.3724739Z ##[debug]ForceRefresh: False
2023-03-21T16:24:22.3763451Z ##[debug]
2023-03-21T16:24:22.3783559Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2] 
2023-03-21T16:24:22.3827764Z ##[debug]=== Request Data ===
2023-03-21T16:24:22.3890956Z ##[debug]Authority Provided? - True
2023-03-21T16:24:22.3907309Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2023-03-21T16:24:22.3924800Z ##[debug]Extra Query Params Keys (space separated) - 
2023-03-21T16:24:22.3939101Z ##[debug]ApiId - AcquireTokenForClient
2023-03-21T16:24:22.3971714Z ##[debug]IsConfidentialClient - True
2023-03-21T16:24:22.3972645Z ##[debug]SendX5C - False
2023-03-21T16:24:22.3983807Z ##[debug]LoginHint ? False
2023-03-21T16:24:22.4000488Z ##[debug]IsBrokerConfigured - False
2023-03-21T16:24:22.4016824Z ##[debug]HomeAccountId - False
2023-03-21T16:24:22.4073326Z ##[debug]CorrelationId - xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2
2023-03-21T16:24:22.4093463Z ##[debug]
2023-03-21T16:24:22.4113429Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2] === Token Acquisition (ClientCredentialRequest) started:
2023-03-21T16:24:22.4128462Z ##[debug]  
2023-03-21T16:24:22.4173334Z ##[debug]  Authority Host: login.microsoftonline.com
2023-03-21T16:24:22.4196202Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2] Access token is not expired. Returning the found cache entry. [Current time (03/21/2023 16:24:22) - Expiration Time (03/21/2023 17:24:20 +00:00) - Extended Expiration Time (03/21/2023 17:24:20 +00:00)]
2023-03-21T16:24:22.4217181Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-3051-4ea5-8b35-bbdcca3f49a2] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 03/21/2023 17:24:20 +00:00 ===
2023-03-21T16:24:22.4238585Z ##[debug]4:24:22 PM - Get-PowerBIAccessToken end processing.
2023-03-21T16:24:22.4271168Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/xxxxxxx-d341-466f-895f-2ef33808bc8c/reports
2023-03-21T16:24:22.4420303Z ##[debug]GET https://api.powerbi.com/v1.0/myorg/groups/xxxxxxx-d341-466f-895f-2ef33808bc8c/reports with 0-byte payload
2023-03-21T16:24:22.6805924Z ##[debug]received -1-byte response of content type application/json; odata.metadata=minimal; odata.streaming=true
2023-03-21T16:24:22.6934010Z ##[debug]Trying to find report 'DASHBOARD_ABBANDONI_TEST_3'
2023-03-21T16:24:22.7015656Z Importing PowerBI File
2023-03-21T16:24:22.8313417Z ##[debug]4:24:22 PM - Get-PowerBIAccessToken begin processing with ParameterSet __AllParameterSets.
2023-03-21T16:24:22.8397169Z ##[debug]4:24:22 PM - Cmdlet version: 1.2.1077.0
2023-03-21T16:24:22.8421642Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22] Found 0 cache accounts and 0 broker accounts
2023-03-21T16:24:22.8443499Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-6a29-4334-8a9e-770d29bb82d2] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(xxxxxxxx-6a29-4334-8a9e-770d29bb82d2)
2023-03-21T16:24:22.8464712Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-6a29-4334-8a9e-770d29bb82d2] === AcquireTokenForClientParameters ===
2023-03-21T16:24:22.8478840Z ##[debug]SendX5C: False
2023-03-21T16:24:22.8493045Z ##[debug]WithAzureRegion: False
2023-03-21T16:24:22.8507909Z ##[debug]RegionToUse: 
2023-03-21T16:24:22.8523906Z ##[debug]ForceRefresh: False
2023-03-21T16:24:22.8539207Z ##[debug]
2023-03-21T16:24:22.8558931Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-6a29-4334-8a9e-770d29bb82d2] 
2023-03-21T16:24:22.8591027Z ##[debug]=== Request Data ===
2023-03-21T16:24:22.8631710Z ##[debug]Authority Provided? - True
2023-03-21T16:24:22.8646588Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2023-03-21T16:24:22.8662530Z ##[debug]Extra Query Params Keys (space separated) - 
2023-03-21T16:24:22.8681529Z ##[debug]ApiId - AcquireTokenForClient
2023-03-21T16:24:22.8696609Z ##[debug]IsConfidentialClient - True
2023-03-21T16:24:22.8740040Z ##[debug]SendX5C - False
2023-03-21T16:24:22.8755678Z ##[debug]LoginHint ? False
2023-03-21T16:24:22.8773756Z ##[debug]IsBrokerConfigured - False
2023-03-21T16:24:22.8790167Z ##[debug]HomeAccountId - False
2023-03-21T16:24:22.8807386Z ##[debug]CorrelationId - xxxxxxxx-6a29-4334-8a9e-770d29bb82d2
2023-03-21T16:24:22.8826782Z ##[debug]
2023-03-21T16:24:22.8850588Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-6a29-4334-8a9e-770d29bb82d2] === Token Acquisition (ClientCredentialRequest) started:
2023-03-21T16:24:22.8891860Z ##[debug]  
2023-03-21T16:24:22.8935877Z ##[debug]  Authority Host: login.microsoftonline.com
2023-03-21T16:24:22.8987510Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-6a29-4334-8a9e-770d29bb82d2] Access token is not expired. Returning the found cache entry. [Current time (03/21/2023 16:24:22) - Expiration Time (03/21/2023 17:24:20 +00:00) - Extended Expiration Time (03/21/2023 17:24:20 +00:00)]
2023-03-21T16:24:22.9010772Z ##[debug](False) MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [03/21/2023 16:24:22 - xxxxxxxx-6a29-4334-8a9e-770d29bb82d2] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 03/21/2023 17:24:20 +00:00 ===
2023-03-21T16:24:22.9032379Z ##[debug]4:24:22 PM - Get-PowerBIAccessToken end processing.
2023-03-21T16:24:22.9056721Z ##[debug]Trying to invoke api: https://api.powerbi.com/v1.0/myorg/groups/xxxxxxx-d341-466f-895f-2ef33808bc8c/imports?datasetDisplayName=DASHBOARD_ABBANDONI_TEST_3.pbix&nameConflict=Abort&skipReport=True
2023-03-21T16:24:22.9932180Z ##[debug]POST https://api.powerbi.com/v1.0/myorg/groups/xxxxxxx-d341-466f-895f-2ef33808bc8c/imports?datasetDisplayName=DASHBOARD_ABBANDONI_TEST_3.pbix&nameConflict=Abort&skipReport=True with -1-byte payload
2023-03-21T16:24:23.2709372Z Done processing Power BI Actions
2023-03-21T16:24:23.2838980Z ##[debug]Caught exception from task script.
2023-03-21T16:24:23.2872173Z ##[debug]Error record:
2023-03-21T16:24:23.3455211Z ##[debug]Invoke-API : The remote server returned an error: (400) Bad Request.
2023-03-21T16:24:23.3523272Z ##[debug]At D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1:655 char:15
2023-03-21T16:24:23.3539080Z ##[debug]+ ...   $result = Invoke-API -Url $url -Method "Post" -Body $body -ContentT ...
2023-03-21T16:24:23.3553816Z ##[debug]+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2023-03-21T16:24:23.3567183Z ##[debug]    + CategoryInfo          : NotSpecified: (:) [Write-Error], WebException
2023-03-21T16:24:23.3611044Z ##[debug]    + FullyQualifiedErrorId : System.Net.WebException,Invoke-API
2023-03-21T16:24:23.3653462Z ##[debug] 
2023-03-21T16:24:23.3674144Z ##[debug]Script stack trace:
2023-03-21T16:24:23.3712150Z ##[debug]at Invoke-API, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1: line 311
2023-03-21T16:24:23.3728795Z ##[debug]at Import-PowerBIFile, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1: line 655
2023-03-21T16:24:23.3814253Z ##[debug]at Publish-PowerBIFileApi, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\ps_modules\PowerBI\PowerBI.psm1: line 862
2023-03-21T16:24:23.3851650Z ##[debug]at <ScriptBlock><Process>, D:\a\_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.39\run.ps1: line 114
2023-03-21T16:24:23.3877128Z ##[debug]at <ScriptBlock>, <No file>: line 1
2023-03-21T16:24:23.3914076Z ##[debug]at <ScriptBlock>, <No file>: line 22
2023-03-21T16:24:23.3930210Z ##[debug]at <ScriptBlock>, <No file>: line 18
2023-03-21T16:24:23.3952456Z ##[debug]at <ScriptBlock>, <No file>: line 1
2023-03-21T16:24:23.3974141Z ##[debug]Exception:
2023-03-21T16:24:23.4056555Z ##[debug]System.Net.WebException: The remote server returned an error: (400) Bad Request.
2023-03-21T16:24:23.4072887Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
2023-03-21T16:24:23.4115533Z ##[debug]   at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
2023-03-21T16:24:23.4352173Z ##[error]The remote server returned an error: (400) Bad Request.
2023-03-21T16:24:23.4362271Z ##[debug]Processed: ##vso[task.logissue type=error]The remote server returned an error: (400) Bad Request.
2023-03-21T16:24:23.4364474Z ##[debug]Processed: ##vso[task.complete result=Failed]
2023-03-21T16:24:23.4662270Z ##[section]Finishing: Publish Dashboard copy
maikvandergaag commented 1 year ago

Could you share screenshots of the configuration? There seems to be something strange in the log:

2023-03-21T16:24:21.4068632Z ##[debug]INPUT_OVERWRITE: 'true' 2023-03-21T16:24:21.4104565Z ##[debug] Converted to bool: False

khem-kandel commented 1 year ago

Any solution or workaround for this yet? I am running into same issue as well.

DavideEva commented 1 year ago

Hi, I don't have the pipeline anymore.

The workaround is to republish the report instead of skipping it.