Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bad Request when publishing a report - Power BI Actions #566

Closed
luke-barnett opened this issue Nov 12, 2024 · 9 comments
Closed

Bad Request when publishing a report - Power BI Actions #566

luke-barnett opened this issue Nov 12, 2024 · 9 comments
Assignees
Labels

Comments

@luke-barnett
Copy link

Describe the issue
A clear and concise description of what the issue is.

**Extension **

  • Extension: Power BI Actions
  • Version: 5.4.54

To Reproduce
Steps to reproduce the behavior:

  1. Simple publish of report via Azure Pipelines
  2. Error 400 Bad request

Expected behavior
The report is published to Power BI

Situation (please complete the following information):

  • Agent type: Windows Hosted
  • Autentication: Service Principal
  • Extension Version: 5.4.54

Log info

2024-11-12T21:11:35.8052145Z ##[debug]Evaluating condition for step: 'Publish PowerBI Report'
2024-11-12T21:11:35.8053507Z ##[debug]Evaluating: SucceededNode()
2024-11-12T21:11:35.8053825Z ##[debug]Evaluating SucceededNode:
2024-11-12T21:11:35.8054823Z ##[debug]=> True
2024-11-12T21:11:35.8055172Z ##[debug]Result: True
2024-11-12T21:11:35.8055488Z ##[section]Starting: Publish PowerBI Report
2024-11-12T21:11:35.8077227Z ==============================================================================
2024-11-12T21:11:35.8077391Z Task : Power BI Actions
2024-11-12T21:11:35.8077637Z Description : Release Task Power BI Actions
2024-11-12T21:11:35.8077755Z Version : 5.4.54
2024-11-12T21:11:35.8077832Z Author : Maik van der Gaag
2024-11-12T21:11:35.8078569Z Help :
2024-11-12T21:11:35.8078687Z ==============================================================================
2024-11-12T21:11:38.0292746Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2024-11-12T21:11:38.0293477Z Starting Power BI Actions extension
2024-11-12T21:11:38.0295277Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1.
2024-11-12T21:11:38.0296891Z ### Required Module is needed. Importing now...
2024-11-12T21:11:38.0297818Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2024-11-12T21:11:38.0299909Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2024-11-12T21:11:38.0300892Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2024-11-12T21:11:38.0302167Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2024-11-12T21:11:38.0303100Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2024-11-12T21:11:38.0303803Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2024-11-12T21:11:38.0304360Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2024-11-12T21:11:38.0304905Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2024-11-12T21:11:38.0305625Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2024-11-12T21:11:38.0306160Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2024-11-12T21:11:38.0306723Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2024-11-12T21:11:38.0308439Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2024-11-12T21:11:38.0309068Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2024-11-12T21:11:38.0339459Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2024-11-12T21:11:38.0340663Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2024-11-12T21:11:38.0342166Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2024-11-12T21:11:38.0343265Z ##[debug]Importing alias 'Login-PowerBI'.
2024-11-12T21:11:38.0344170Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2024-11-12T21:11:38.0345056Z ##[debug]Importing alias 'Logout-PowerBI'.
2024-11-12T21:11:38.0345989Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2024-11-12T21:11:38.0346903Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2024-11-12T21:11:38.0348409Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2024-11-12T21:11:38.0350027Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2024-11-12T21:11:38.0351413Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2024-11-12T21:11:38.0354738Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2024-11-12T21:11:38.0356351Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2024-11-12T21:11:38.0362538Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2024-11-12T21:11:38.0363007Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2024-11-12T21:11:38.0363636Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2024-11-12T21:11:38.0364257Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2024-11-12T21:11:38.0364850Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2024-11-12T21:11:38.0365280Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2024-11-12T21:11:38.0365690Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2024-11-12T21:11:38.0366115Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2024-11-12T21:11:38.0366536Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2024-11-12T21:11:38.0366969Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2024-11-12T21:11:38.0367397Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2024-11-12T21:11:38.0367820Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2024-11-12T21:11:38.0368248Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2024-11-12T21:11:38.0368656Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2024-11-12T21:11:38.0369082Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2024-11-12T21:11:38.0369495Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2024-11-12T21:11:38.0369977Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2024-11-12T21:11:38.0370403Z ##[debug]Importing alias 'New-PowerBIGroup'.
2024-11-12T21:11:38.0370823Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2024-11-12T21:11:38.0371225Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2024-11-12T21:11:38.0387016Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2024-11-12T21:11:38.0430657Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2024-11-12T21:11:38.0908463Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2024-11-12T21:11:38.0931608Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2024-11-12T21:11:38.0933083Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2024-11-12T21:11:38.0934152Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2024-11-12T21:11:38.0935137Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2024-11-12T21:11:38.0936133Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2024-11-12T21:11:38.0937126Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2024-11-12T21:11:38.0938329Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2024-11-12T21:11:38.0939338Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2024-11-12T21:11:38.0940776Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2024-11-12T21:11:38.0941850Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2024-11-12T21:11:38.0960060Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2024-11-12T21:11:38.0980545Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2024-11-12T21:11:38.0999242Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2024-11-12T21:11:38.1019025Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2024-11-12T21:11:38.1060156Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2024-11-12T21:11:38.1061456Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2024-11-12T21:11:38.1081171Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2024-11-12T21:11:38.1087392Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2024-11-12T21:11:38.1135922Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2024-11-12T21:11:38.1137443Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2024-11-12T21:11:38.1156501Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2024-11-12T21:11:38.1196216Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2024-11-12T21:11:38.1273013Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2024-11-12T21:11:38.1293055Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2024-11-12T21:11:38.1705562Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2024-11-12T21:11:38.1802441Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2024-11-12T21:11:38.1847988Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2024-11-12T21:11:38.1849781Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2024-11-12T21:11:38.1873031Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2024-11-12T21:11:38.1908286Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2024-11-12T21:11:38.1909556Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2024-11-12T21:11:38.1927193Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2024-11-12T21:11:38.1964986Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2024-11-12T21:11:38.2001779Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2024-11-12T21:11:38.2033687Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2024-11-12T21:11:38.2052711Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2024-11-12T21:11:38.2075892Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2024-11-12T21:11:38.2097797Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2024-11-12T21:11:38.2127863Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2024-11-12T21:11:38.2149560Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2024-11-12T21:11:38.2168614Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2024-11-12T21:11:38.2188883Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2024-11-12T21:11:38.2213713Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2024-11-12T21:11:38.2230673Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2024-11-12T21:11:38.2254182Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2024-11-12T21:11:38.2273820Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2024-11-12T21:11:38.2299755Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2024-11-12T21:11:38.2341939Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2024-11-12T21:11:38.2365892Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2024-11-12T21:11:38.2433018Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2024-11-12T21:11:38.2453804Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2024-11-12T21:11:38.2503172Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2024-11-12T21:11:38.2508320Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2024-11-12T21:11:38.2513580Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2024-11-12T21:11:38.2527253Z ### Trying to import the incorporated module for PowerBI
2024-11-12T21:11:38.2553206Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1'.
2024-11-12T21:11:38.4024397Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2024-11-12T21:11:38.4064290Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2024-11-12T21:11:38.4085934Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2024-11-12T21:11:38.4106534Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2024-11-12T21:11:38.4151302Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2024-11-12T21:11:38.4170963Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2024-11-12T21:11:38.4191249Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2024-11-12T21:11:38.4209977Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2024-11-12T21:11:38.4231084Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2024-11-12T21:11:38.4250382Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2024-11-12T21:11:38.4269608Z ##[debug]Exporting function 'Invoke-API'.
2024-11-12T21:11:38.4288640Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2024-11-12T21:11:38.4308305Z ##[debug]Exporting function 'New-DatasetRefresh'.
2024-11-12T21:11:38.4328516Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2024-11-12T21:11:38.4349473Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2024-11-12T21:11:38.4370722Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2024-11-12T21:11:38.4389769Z ##[debug]Exporting function 'Get-PowerBIReport'.
2024-11-12T21:11:38.4408944Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2024-11-12T21:11:38.4447053Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2024-11-12T21:11:38.4478176Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2024-11-12T21:11:38.4483824Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2024-11-12T21:11:38.4505236Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2024-11-12T21:11:38.4525681Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2024-11-12T21:11:38.4544376Z ##[debug]Exporting function 'Import-PowerBIFile'.
2024-11-12T21:11:38.4562851Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2024-11-12T21:11:38.4581093Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2024-11-12T21:11:38.4600507Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2024-11-12T21:11:38.4624243Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2024-11-12T21:11:38.4668698Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2024-11-12T21:11:38.4688155Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2024-11-12T21:11:38.4707905Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2024-11-12T21:11:38.4729162Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2024-11-12T21:11:38.4738662Z ##[debug]Exporting function 'Set-Capacity'.
2024-11-12T21:11:38.4752495Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2024-11-12T21:11:38.4772822Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2024-11-12T21:11:38.4792197Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2024-11-12T21:11:38.4811437Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2024-11-12T21:11:38.4832864Z ##[debug]Exporting function 'Publish-TabularEditor'.
2024-11-12T21:11:38.4852390Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'.
2024-11-12T21:11:38.4872544Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'.
2024-11-12T21:11:38.4911472Z ##[debug]Exporting function 'Set-PowerBIDatasourceCredentials'.
2024-11-12T21:11:38.4931074Z ##[debug]Exporting function 'Update-DatasourceCredentialsInGateway'.
2024-11-12T21:11:38.4961743Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'.
2024-11-12T21:11:38.4982230Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2024-11-12T21:11:38.5004396Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2024-11-12T21:11:38.5024032Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2024-11-12T21:11:38.5042725Z ##[debug]Importing function 'Get-PowerBICapacity'.
2024-11-12T21:11:38.5063323Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2024-11-12T21:11:38.5082354Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2024-11-12T21:11:38.5101753Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2024-11-12T21:11:38.5120671Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2024-11-12T21:11:38.5152741Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'.
2024-11-12T21:11:38.5184066Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2024-11-12T21:11:38.5236757Z ##[debug]Importing function 'Get-PowerBIGateways'.
2024-11-12T21:11:38.5254928Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2024-11-12T21:11:38.5283028Z ##[debug]Importing function 'Get-PowerBiParameters'.
2024-11-12T21:11:38.5306443Z ##[debug]Importing function 'Get-PowerBIReport'.
2024-11-12T21:11:38.5326772Z ##[debug]Importing function 'Import-PowerBIFile'.
2024-11-12T21:11:38.5348703Z ##[debug]Importing function 'Invoke-API'.
2024-11-12T21:11:38.5369611Z ##[debug]Importing function 'New-DatasetRefresh'.
2024-11-12T21:11:38.5392163Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2024-11-12T21:11:38.5415695Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2024-11-12T21:11:38.5437952Z ##[debug]Importing function 'Publish-PowerBIFile'.
2024-11-12T21:11:38.5462608Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2024-11-12T21:11:38.5485562Z ##[debug]Importing function 'Publish-TabularEditor'.
2024-11-12T21:11:38.5506638Z ##[debug]Importing function 'Redo-PowerBIReport'.
2024-11-12T21:11:38.5528219Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2024-11-12T21:11:38.5549813Z ##[debug]Importing function 'Remove-PowerBIReport'.
2024-11-12T21:11:38.5572267Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2024-11-12T21:11:38.5592642Z ##[debug]Importing function 'Set-Capacity'.
2024-11-12T21:11:38.5613042Z ##[debug]Importing function 'Set-DatasetOwnership'.
2024-11-12T21:11:38.5636983Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2024-11-12T21:11:38.5659590Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2024-11-12T21:11:38.5686846Z ##[debug]Importing function 'Set-PowerBIDatasourceCredentials'.
2024-11-12T21:11:38.5708344Z ##[debug]Importing function 'Set-RefreshSchedule'.
2024-11-12T21:11:38.5731337Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2024-11-12T21:11:38.5752266Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2024-11-12T21:11:38.5773631Z ##[debug]Importing function 'Update-DatasourceCredentialsInGateway'.
2024-11-12T21:11:38.5799175Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2024-11-12T21:11:38.5817788Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2024-11-12T21:11:38.5837094Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2024-11-12T21:11:38.5859271Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2024-11-12T21:11:38.5883232Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2024-11-12T21:11:38.5903165Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2024-11-12T21:11:38.6349926Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '235bbd85-cd97-4572-829f-8c873ba91c9d'
2024-11-12T21:11:38.6507460Z ##[debug]ENDPOINT_URL_235bbd85-cd97-4572-829f-8c873ba91c9d: 'https://api.powerbi.com/v1.0/myorg'
2024-11-12T21:11:38.6535657Z ##[debug]ENDPOINT_AUTH_235bbd85-cd97-4572-829f-8c873ba91c9d: '**'
2024-11-12T21:11:38.6566560Z ##[debug]ENDPOINT_DATA_235bbd85-cd97-4572-829f-8c873ba91c9d: '{"OrganizationType":"Public"}'
2024-11-12T21:11:38.7505216Z ##[debug]{
2024-11-12T21:11:38.7515929Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg",
2024-11-12T21:11:38.7525827Z ##[debug] "Data": {
2024-11-12T21:11:38.7542120Z ##[debug] "OrganizationType": "Public"
2024-11-12T21:11:38.7557861Z ##[debug] },
2024-11-12T21:11:38.7572981Z ##[debug] "Auth": {
2024-11-12T21:11:38.7590772Z ##[debug] "parameters": {
2024-11-12T21:11:38.7605342Z ##[debug] "TenantId": "
",
2024-11-12T21:11:38.7620771Z ##[debug] "ClientId": "
",
2024-11-12T21:11:38.7637129Z ##[debug] "ClientCertificate": "",
2024-11-12T21:11:38.7655507Z ##[debug] "ClientSecret": ***
2024-11-12T21:11:38.7670292Z ##[debug] },
2024-11-12T21:11:38.7692490Z ##[debug] "scheme": "None"
2024-11-12T21:11:38.7709633Z ##[debug] }
2024-11-12T21:11:38.7725281Z ##[debug]}
2024-11-12T21:11:39.3299729Z ##[debug]9:11:39 PM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2024-11-12T21:11:39.3329020Z ##[debug]9:11:39 PM - Cmdlet version: 1.2.1077.0
2024-11-12T21:11:39.3766681Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/94260f03-0793-484a-91cf-bebe584319bc
2024-11-12T21:11:39.5263087Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39] Found 0 cache accounts and 0 broker accounts
2024-11-12T21:11:39.5351977Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(5185ae52-aaf0-4b38-be7d-b3afc1ff21db)
2024-11-12T21:11:39.5390591Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] === AcquireTokenForClientParameters ===
2024-11-12T21:11:39.5409387Z ##[debug]SendX5C: False
2024-11-12T21:11:39.5437030Z ##[debug]WithAzureRegion: False
2024-11-12T21:11:39.5444445Z ##[debug]RegionToUse:
2024-11-12T21:11:39.5461133Z ##[debug]ForceRefresh: False
2024-11-12T21:11:39.5478378Z ##[debug]
2024-11-12T21:11:39.5644957Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db]
2024-11-12T21:11:39.5661945Z ##[debug]=== Request Data ===
2024-11-12T21:11:39.5678326Z ##[debug]Authority Provided? - True
2024-11-12T21:11:39.5696123Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-12T21:11:39.5711631Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-12T21:11:39.5730814Z ##[debug]ApiId - AcquireTokenForClient
2024-11-12T21:11:39.5755961Z ##[debug]IsConfidentialClient - True
2024-11-12T21:11:39.5775729Z ##[debug]SendX5C - False
2024-11-12T21:11:39.5795128Z ##[debug]LoginHint ? False
2024-11-12T21:11:39.5815821Z ##[debug]IsBrokerConfigured - False
2024-11-12T21:11:39.5833470Z ##[debug]HomeAccountId - False
2024-11-12T21:11:39.5849861Z ##[debug]CorrelationId - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db
2024-11-12T21:11:39.5865347Z ##[debug]
2024-11-12T21:11:39.5907070Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] === Token Acquisition (ClientCredentialRequest) started:
2024-11-12T21:11:39.5922913Z ##[debug]
2024-11-12T21:11:39.5957971Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-12T21:11:39.6375446Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Fetching instance discovery from the network from host login.microsoftonline.com.
2024-11-12T21:11:40.1238721Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:39 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Resolving authority endpoints... Already resolved? - FALSE
2024-11-12T21:11:40.1266164Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] ScopeSet was missing from the token response, so using developer provided scopes in the result.
2024-11-12T21:11:40.1289880Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Checking client info returned from the server..
2024-11-12T21:11:40.1314710Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Saving Token Response to cache..
2024-11-12T21:11:40.1339515Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] ID Token not present in response.
2024-11-12T21:11:40.1417845Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Saving AT in cache and removing overlapping ATs...
2024-11-12T21:11:40.1419664Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2024-11-12T21:11:40.1437653Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] Intersecting scope entries count - 0
2024-11-12T21:11:40.1458941Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - 5185ae52-aaf0-4b38-be7d-b3afc1ff21db] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 ===
2024-11-12T21:11:40.1485572Z ##[debug]9:11:40 PM - Connect-PowerBIServiceAccount end processing.
2024-11-12T21:11:40.1892433Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\report*.pbix'
2024-11-12T21:11:40.1922864Z ##[debug]INPUT_WORKSPACENAME: 'report-dev'
2024-11-12T21:11:40.1950411Z ##[debug]INPUT_OVERWRITE: 'true'
2024-11-12T21:11:40.2001166Z ##[debug] Converted to bool: True
2024-11-12T21:11:40.2030242Z ##[debug]INPUT_CREATE: 'false'
2024-11-12T21:11:40.2054102Z ##[debug] Converted to bool: False
2024-11-12T21:11:40.2082798Z ##[debug]INPUT_ACTION: 'Publish'
2024-11-12T21:11:40.2110141Z ##[debug]INPUT_DATASETNAME (empty)
2024-11-12T21:11:40.2167628Z ##[debug]INPUT_OLDURL (empty)
2024-11-12T21:11:40.2201925Z ##[debug]INPUT_NEWURL (empty)
2024-11-12T21:11:40.2222990Z ##[debug]INPUT_OLDSERVER (empty)
2024-11-12T21:11:40.2249573Z ##[debug]INPUT_NEWSERVER (empty)
2024-11-12T21:11:40.2277517Z ##[debug]INPUT_OLDDATABASE (empty)
2024-11-12T21:11:40.2308338Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2024-11-12T21:11:40.2334649Z ##[debug]INPUT_NEWDATABASE (empty)
2024-11-12T21:11:40.2364248Z ##[debug]INPUT_PERMISSION (empty)
2024-11-12T21:11:40.2393284Z ##[debug]INPUT_USERS (empty)
2024-11-12T21:11:40.2436025Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2024-11-12T21:11:40.2478257Z ##[debug]INPUT_UPDATEALL: 'false'
2024-11-12T21:11:40.2514982Z ##[debug] Converted to bool: False
2024-11-12T21:11:40.2558670Z ##[debug]INPUT_SKIPREPORT: 'false'
2024-11-12T21:11:40.2585544Z ##[debug] Converted to bool: False
2024-11-12T21:11:40.2627934Z ##[debug]INPUT_SCOPE: 'Private'
2024-11-12T21:11:40.2657993Z ##[debug]INPUT_SERVICEPRINCIPALS (empty)
2024-11-12T21:11:40.2686551Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2024-11-12T21:11:40.2714502Z ##[debug]INPUT_PARAMETERINPUT (empty)
2024-11-12T21:11:40.2742693Z ##[debug]INPUT_GATEWAYNAME (empty)
2024-11-12T21:11:40.2791017Z ##[debug]INPUT_REPORTNAME (empty)
2024-11-12T21:11:40.2807642Z ##[debug]INPUT_CAPACITYNAME (empty)
2024-11-12T21:11:40.2821133Z ##[debug]INPUT_USERNAME (empty)
2024-11-12T21:11:40.2848785Z ##[debug]INPUT_PASSWORD (empty)
2024-11-12T21:11:40.3718437Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2024-11-12T21:11:40.3721517Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2024-11-12T21:11:40.3749674Z ##[debug] Converted to bool: False
2024-11-12T21:11:40.3776247Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2024-11-12T21:11:40.3802532Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2024-11-12T21:11:40.3851411Z ##[debug]INPUT_PRINCIPALTYPE: 'User'
2024-11-12T21:11:40.3881641Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty)
2024-11-12T21:11:40.3908179Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty)
2024-11-12T21:11:40.3934750Z ##[debug]INPUT_DATASETACCESSRIGHT (empty)
2024-11-12T21:11:40.3958877Z ##[debug]INPUT_SERVER (empty)
2024-11-12T21:11:40.3983860Z ##[debug]INPUT_DATABASE (empty)
2024-11-12T21:11:40.4006933Z ##[debug]INPUT_TENANTID (empty)
2024-11-12T21:11:40.4037739Z ##[debug]INPUT_SERVICEPRINCIPALID (empty)
2024-11-12T21:11:40.4072204Z ##[debug]INPUT_SERVICEPRINCIPALKEY (empty)
2024-11-12T21:11:40.4079137Z ##[debug]WorkspaceName : report-dev
2024-11-12T21:11:40.4100678Z ##[debug]Create : False
2024-11-12T21:11:40.4120694Z ##[debug]File patern : D:\a\1\report*.pbix
2024-11-12T21:11:40.4140970Z ##[debug]Remove report : False
2024-11-12T21:11:40.4343056Z Getting Power BI Workspace properties; report-dev
2024-11-12T21:11:40.4422197Z ##[debug]9:11:40 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2024-11-12T21:11:40.4442752Z ##[debug]9:11:40 PM - Cmdlet version: 1.2.1077.0
2024-11-12T21:11:40.5001617Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40] Found 0 cache accounts and 0 broker accounts
2024-11-12T21:11:40.5021798Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(bbb8b42e-6e6e-444f-b35a-0e54ad592dcc)
2024-11-12T21:11:40.5043635Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] === AcquireTokenForClientParameters ===
2024-11-12T21:11:40.5057365Z ##[debug]SendX5C: False
2024-11-12T21:11:40.5086928Z ##[debug]WithAzureRegion: False
2024-11-12T21:11:40.5100954Z ##[debug]RegionToUse:
2024-11-12T21:11:40.5115979Z ##[debug]ForceRefresh: False
2024-11-12T21:11:40.5129900Z ##[debug]
2024-11-12T21:11:40.5152994Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc]
2024-11-12T21:11:40.5167845Z ##[debug]=== Request Data ===
2024-11-12T21:11:40.5182364Z ##[debug]Authority Provided? - True
2024-11-12T21:11:40.5196612Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-12T21:11:40.5211185Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-12T21:11:40.5229626Z ##[debug]ApiId - AcquireTokenForClient
2024-11-12T21:11:40.5246327Z ##[debug]IsConfidentialClient - True
2024-11-12T21:11:40.5261512Z ##[debug]SendX5C - False
2024-11-12T21:11:40.5295667Z ##[debug]LoginHint ? False
2024-11-12T21:11:40.5312720Z ##[debug]IsBrokerConfigured - False
2024-11-12T21:11:40.5329194Z ##[debug]HomeAccountId - False
2024-11-12T21:11:40.5345715Z ##[debug]CorrelationId - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc
2024-11-12T21:11:40.5359617Z ##[debug]
2024-11-12T21:11:40.5381633Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] === Token Acquisition (ClientCredentialRequest) started:
2024-11-12T21:11:40.5397918Z ##[debug]
2024-11-12T21:11:40.5412933Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-12T21:11:40.5479349Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] Access token is not expired. Returning the found cache entry. [Current time (11/12/2024 21:11:40) - Expiration Time (11/12/2024 22:11:39 +00:00) - Extended Expiration Time (11/12/2024 22:11:39 +00:00)]
2024-11-12T21:11:40.5514960Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:40 - bbb8b42e-6e6e-444f-b35a-0e54ad592dcc] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 ===
2024-11-12T21:11:41.3761829Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'report-dev'&$top=100
2024-11-12T21:11:41.3781968Z ##[debug]Status Code: OK (200)
2024-11-12T21:11:41.3803451Z ##[debug]9:11:41 PM - Get-PowerBIWorkspace end processing.
2024-11-12T21:11:41.3878789Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]b13833a5-3cff-4582-9c20-b1898fa06718
2024-11-12T21:11:41.3905855Z ##[debug]9:11:41 PM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2024-11-12T21:11:41.3933752Z ##[debug]9:11:41 PM - Cmdlet version: 1.2.1077.0
2024-11-12T21:11:41.3957568Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41] Found 0 cache accounts and 0 broker accounts
2024-11-12T21:11:41.3979349Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(e839bf6c-b727-4eb1-a366-cf76aa388421)
2024-11-12T21:11:41.3999595Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] === AcquireTokenForClientParameters ===
2024-11-12T21:11:41.4014193Z ##[debug]SendX5C: False
2024-11-12T21:11:41.4029836Z ##[debug]WithAzureRegion: False
2024-11-12T21:11:41.4044429Z ##[debug]RegionToUse:
2024-11-12T21:11:41.4059758Z ##[debug]ForceRefresh: False
2024-11-12T21:11:41.4076673Z ##[debug]
2024-11-12T21:11:41.4098483Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421]
2024-11-12T21:11:41.4113934Z ##[debug]=== Request Data ===
2024-11-12T21:11:41.4129580Z ##[debug]Authority Provided? - True
2024-11-12T21:11:41.4144472Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-12T21:11:41.4160336Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-12T21:11:41.4177593Z ##[debug]ApiId - AcquireTokenForClient
2024-11-12T21:11:41.4192519Z ##[debug]IsConfidentialClient - True
2024-11-12T21:11:41.4206789Z ##[debug]SendX5C - False
2024-11-12T21:11:41.4220657Z ##[debug]LoginHint ? False
2024-11-12T21:11:41.4240480Z ##[debug]IsBrokerConfigured - False
2024-11-12T21:11:41.4255250Z ##[debug]HomeAccountId - False
2024-11-12T21:11:41.4270246Z ##[debug]CorrelationId - e839bf6c-b727-4eb1-a366-cf76aa388421
2024-11-12T21:11:41.4286212Z ##[debug]
2024-11-12T21:11:41.4308569Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] === Token Acquisition (ClientCredentialRequest) started:
2024-11-12T21:11:41.4323573Z ##[debug]
2024-11-12T21:11:41.4343090Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-12T21:11:41.4367267Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] Access token is not expired. Returning the found cache entry. [Current time (11/12/2024 21:11:41) - Expiration Time (11/12/2024 22:11:39 +00:00) - Extended Expiration Time (11/12/2024 22:11:39 +00:00)]
2024-11-12T21:11:41.4390067Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - e839bf6c-b727-4eb1-a366-cf76aa388421] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 ===
2024-11-12T21:11:41.8661962Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'report-dev'&$top=100
2024-11-12T21:11:41.8682774Z ##[debug]Status Code: OK (200)
2024-11-12T21:11:41.8703002Z ##[debug]9:11:41 PM - Get-PowerBIWorkspace end processing.
2024-11-12T21:11:41.8805558Z Trying to publish PowerBI File: D:\a\1\report\report.pbix
2024-11-12T21:11:41.8856845Z Checking for existing Reports with the name: report
2024-11-12T21:11:41.8937609Z ##[debug]9:11:41 PM - New-PowerBIReport begin processing with ParameterSet Workspace.
2024-11-12T21:11:41.9006122Z ##[debug]9:11:41 PM - Cmdlet version: 1.2.1077.0
2024-11-12T21:11:41.9045343Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41] Found 0 cache accounts and 0 broker accounts
2024-11-12T21:11:41.9064688Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(72fec461-0cd1-41cb-bdba-f84f31a0f6be)
2024-11-12T21:11:41.9086109Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] === AcquireTokenForClientParameters ===
2024-11-12T21:11:41.9100984Z ##[debug]SendX5C: False
2024-11-12T21:11:41.9116171Z ##[debug]WithAzureRegion: False
2024-11-12T21:11:41.9131960Z ##[debug]RegionToUse:
2024-11-12T21:11:41.9147283Z ##[debug]ForceRefresh: False
2024-11-12T21:11:41.9161507Z ##[debug]
2024-11-12T21:11:41.9184133Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be]
2024-11-12T21:11:41.9199461Z ##[debug]=== Request Data ===
2024-11-12T21:11:41.9214925Z ##[debug]Authority Provided? - True
2024-11-12T21:11:41.9230275Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-12T21:11:41.9956196Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-12T21:11:41.9971404Z ##[debug]ApiId - AcquireTokenForClient
2024-11-12T21:11:41.9986917Z ##[debug]IsConfidentialClient - True
2024-11-12T21:11:42.0001512Z ##[debug]SendX5C - False
2024-11-12T21:11:42.0019173Z ##[debug]LoginHint ? False
2024-11-12T21:11:42.0034062Z ##[debug]IsBrokerConfigured - False
2024-11-12T21:11:42.0048120Z ##[debug]HomeAccountId - False
2024-11-12T21:11:42.0063549Z ##[debug]CorrelationId - 72fec461-0cd1-41cb-bdba-f84f31a0f6be
2024-11-12T21:11:42.0079126Z ##[debug]
2024-11-12T21:11:42.0113636Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:41 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] === Token Acquisition (ClientCredentialRequest) started:
2024-11-12T21:11:42.0128590Z ##[debug]
2024-11-12T21:11:42.0143641Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-12T21:11:42.0167068Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:42 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] Access token is not expired. Returning the found cache entry. [Current time (11/12/2024 21:11:42) - Expiration Time (11/12/2024 22:11:39 +00:00) - Extended Expiration Time (11/12/2024 22:11:39 +00:00)]
2024-11-12T21:11:42.0194126Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/12/2024 21:11:42 - 72fec461-0cd1-41cb-bdba-f84f31a0f6be] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/12/2024 22:11:39 +00:00 ===
2024-11-12T21:11:43.0278438Z ##[debug]Agent environment resources - Disk: D:\ Available 12446.73 MB out of 14334.00 MB, Memory: Used 2029.00 MB out of 7167.00 MB, CPU: Usage 45.00%
2024-11-12T21:11:44.5557248Z Done processing Power BI Actions
2024-11-12T21:11:44.6294147Z ##[debug]Caught exception from task script.
2024-11-12T21:11:44.6330275Z ##[debug]Error record:
2024-11-12T21:11:44.7065333Z ##[debug]New-PowerBIReport : Operation returned an invalid status code 'BadRequest'
2024-11-12T21:11:44.7080369Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1:797 char:27
2024-11-12T21:11:44.7094613Z ##[debug]+ ... $report = New-PowerBIReport -Path $filePath -Name $fileToPublish -W ...
2024-11-12T21:11:44.7108983Z ##[debug]+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2024-11-12T21:11:44.7123582Z ##[debug] + CategoryInfo : WriteError: (Microsoft.Power...ewPowerBIReport:NewPowerBIReport) [New-PowerBIReport], Ht tpOperationException
2024-11-12T21:11:44.7151750Z ##[debug] + FullyQualifiedErrorId : Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Report s.NewPowerBIReport
2024-11-12T21:11:44.7168896Z ##[debug]
2024-11-12T21:11:44.7193747Z ##[debug]Script stack trace:
2024-11-12T21:11:44.7247194Z ##[debug]at Publish-PowerBIFile, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1: line 797
2024-11-12T21:11:44.7261850Z ##[debug]at , D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1: line 117
2024-11-12T21:11:44.7282584Z ##[debug]at , : line 1
2024-11-12T21:11:44.7307745Z ##[debug]at , : line 22
2024-11-12T21:11:44.7327599Z ##[debug]at , : line 18
2024-11-12T21:11:44.7344988Z ##[debug]at , : line 1
2024-11-12T21:11:44.7370880Z ##[debug]Exception:
2024-11-12T21:11:44.7674427Z ##[debug]Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'BadRequest'
2024-11-12T21:11:44.7687710Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d__8.MoveNext()
2024-11-12T21:11:44.7704566Z ##[debug]--- End of stack trace from previous location where exception was thrown ---
2024-11-12T21:11:44.7719082Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
2024-11-12T21:11:44.7734557Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
2024-11-12T21:11:44.7751620Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d__7.MoveNext()
2024-11-12T21:11:44.7767786Z ##[debug]--- End of stack trace from previous location where exception was thrown ---
2024-11-12T21:11:44.7782200Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
2024-11-12T21:11:44.7796160Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
2024-11-12T21:11:44.7810834Z ##[debug] at Microsoft.PowerBI.Api.V2.ImportsExtensions.PostImportWithFileInGroup(IImports operations, String groupId, Stream fileStream, String datasetDisplayName, String nameConflict, Nullable`1 skipReport)
2024-11-12T21:11:44.7826312Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostImportForWorkspace(Guid workspaceId, String datasetDisplayName, String filePath, ImportConflictHandlerModeEnum nameConflict)
2024-11-12T21:11:44.7844890Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostReportForWorkspace(Guid workspaceId, String reportName, String filePath, ImportConflictHandlerModeEnum nameConflict, Int32 timeout)
2024-11-12T21:11:44.7857591Z ##[debug] at Microsoft.PowerBI.Commands.Reports.NewPowerBIReport.ExecuteCmdlet()
2024-11-12T21:11:44.7871741Z ##[debug] at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord()
2024-11-12T21:11:44.8186048Z ##[error]Operation returned an invalid status code 'BadRequest'
2024-11-12T21:11:44.8196355Z ##[debug]Processed: ##vso[task.logissue type=error]Operation returned an invalid status code 'BadRequest'
2024-11-12T21:11:44.8207304Z ##[debug]Processed: ##vso[task.complete result=Failed]
2024-11-12T21:11:44.8535459Z ##[section]Finishing: Publish PowerBI Report

Additional information
Installed the same version of the Power BI PowerShell modules (noted that they were behind a bit) locally and authenticated with the service principal and it worked without any issues, so I'm really confused as I had started to assume that it was just a permissions issue.

Also confusing to me is that it can successfully authenticate to find the appropriate workspace.

@luke-barnett
Copy link
Author

luke-barnett commented Nov 12, 2024

Here is the pipeline definition:

- task: PowerBIActions@5
  displayName: 'Publish PowerBI Report'
  inputs:
    Action: 'Publish'
    PowerBIServiceEndpoint: ${{ parameters.PowerBIServiceEndpoint }}
    WorkspaceName: ${{ parameters.workspace }}
    PowerBIPath: '$(Pipeline.Workspace)/report/*.pbix'
    Create: false

@maikvandergaag
Copy link
Owner

Would you mind trying it with setting a reference to one specific report

@luke-barnett
Copy link
Author

Updated and ran with the following with the same Bad Request result:

- task: PowerBIActions@5
  displayName: 'Publish PowerBI Report'
  inputs:
    Action: 'Publish'
    PowerBIServiceEndpoint: ${{ parameters.PowerBIServiceEndpoint }}
    WorkspaceName: ${{ parameters.workspace }}
    PowerBIPath: '$(Pipeline.Workspace)/report/report.pbix'
    Create: false

@luke-barnett
Copy link
Author

The part I'm keen to know initially is what flags etc. can I set to get some extra detail on what the issue actually is as just a 400 response makes it really hard to decide what direction to try next.

@maikvandergaag
Copy link
Owner

I understand more information does not come from the unlaying PowerBI Module. Could you share another log file of the last execution?

@luke-barnett
Copy link
Author

2024-11-15T01:55:15.9997183Z ##[debug]Evaluating condition for step: 'Publish PowerBI Report'
2024-11-15T01:55:15.9998829Z ##[debug]Evaluating: SucceededNode()
2024-11-15T01:55:15.9999174Z ##[debug]Evaluating SucceededNode:
2024-11-15T01:55:16.0000340Z ##[debug]=> True
2024-11-15T01:55:16.0000691Z ##[debug]Result: True
2024-11-15T01:55:16.0001195Z ##[section]Starting: Publish PowerBI Report
2024-11-15T01:55:16.0028120Z ==============================================================================
2024-11-15T01:55:16.0028432Z Task : Power BI Actions
2024-11-15T01:55:16.0028504Z Description : Release Task Power BI Actions
2024-11-15T01:55:16.0028606Z Version : 5.4.54
2024-11-15T01:55:16.0028671Z Author : Maik van der Gaag
2024-11-15T01:55:16.0029382Z Help :
2024-11-15T01:55:16.0029500Z ==============================================================================
2024-11-15T01:55:17.2481161Z ##[debug]VstsTaskSdk 0.10.0 commit 787a46ec0a2df5b4d12c2e801bd3f319975c054c
2024-11-15T01:55:17.4883918Z Starting Power BI Actions extension
2024-11-15T01:55:17.5034123Z ##[debug]Entering D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1.
2024-11-15T01:55:17.5120743Z ### Required Module is needed. Importing now...
2024-11-15T01:55:17.5170917Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\MicrosoftPowerBIMgmt.Profile.psd1'.
2024-11-15T01:55:17.5254938Z ##[debug]Loading 'TypesToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.types.ps1xml'.
2024-11-15T01:55:17.5346450Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077\Microsoft.PowerBI.Commands.Profile.format.ps1xml'.
2024-11-15T01:55:17.5575901Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Profile.
2024-11-15T01:55:17.5605793Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Profile\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Profile.dll'.
2024-11-15T01:55:17.5733601Z ##[debug]Exporting cmdlet 'Connect-PowerBIServiceAccount'.
2024-11-15T01:55:17.5787423Z ##[debug]Exporting cmdlet 'Disconnect-PowerBIServiceAccount'.
2024-11-15T01:55:17.5788613Z ##[debug]Exporting cmdlet 'Get-PowerBIAccessToken'.
2024-11-15T01:55:17.5792759Z ##[debug]Exporting cmdlet 'Invoke-PowerBIRestMethod'.
2024-11-15T01:55:17.5815232Z ##[debug]Exporting cmdlet 'Resolve-PowerBIError'.
2024-11-15T01:55:17.5841188Z ##[debug]Importing cmdlet 'Connect-PowerBIServiceAccount'.
2024-11-15T01:55:17.5871515Z ##[debug]Importing cmdlet 'Disconnect-PowerBIServiceAccount'.
2024-11-15T01:55:17.5891334Z ##[debug]Importing cmdlet 'Get-PowerBIAccessToken'.
2024-11-15T01:55:17.5912566Z ##[debug]Importing cmdlet 'Invoke-PowerBIRestMethod'.
2024-11-15T01:55:17.5934611Z ##[debug]Importing cmdlet 'Resolve-PowerBIError'.
2024-11-15T01:55:17.5956744Z ##[debug]Importing alias 'Add-PowerBIServiceAccount'.
2024-11-15T01:55:17.5977581Z ##[debug]Importing alias 'Login-PowerBI'.
2024-11-15T01:55:17.5997024Z ##[debug]Importing alias 'Login-PowerBIServiceAccount'.
2024-11-15T01:55:17.6019771Z ##[debug]Importing alias 'Logout-PowerBI'.
2024-11-15T01:55:17.6040697Z ##[debug]Importing alias 'Logout-PowerBIServiceAccount'.
2024-11-15T01:55:17.6060882Z ##[debug]Importing alias 'Remove-PowerBIServiceAccount'.
2024-11-15T01:55:17.6079752Z ##[debug]Importing alias 'Set-PowerBIServiceAccount'.
2024-11-15T01:55:17.6119039Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\MicrosoftPowerBIMgmt.Workspaces.psd1'.
2024-11-15T01:55:17.6198675Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077\Microsoft.PowerBI.Commands.Workspaces.format.ps1xml'.
2024-11-15T01:55:17.6434497Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Workspaces.
2024-11-15T01:55:17.6466424Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Workspaces\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Workspaces.dll'.
2024-11-15T01:55:17.6578704Z ##[debug]Exporting cmdlet 'Add-PowerBIWorkspaceUser'.
2024-11-15T01:55:17.6598143Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspace'.
2024-11-15T01:55:17.7850489Z ##[debug]Exporting cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2024-11-15T01:55:17.7855412Z ##[debug]Exporting cmdlet 'New-PowerBIWorkspace'.
2024-11-15T01:55:17.7886208Z ##[debug]Exporting cmdlet 'Remove-PowerBIWorkspaceUser'.
2024-11-15T01:55:17.7933747Z ##[debug]Exporting cmdlet 'Restore-PowerBIWorkspace'.
2024-11-15T01:55:17.7938668Z ##[debug]Exporting cmdlet 'Set-PowerBIWorkspace'.
2024-11-15T01:55:17.7962200Z ##[debug]Importing cmdlet 'Add-PowerBIWorkspaceUser'.
2024-11-15T01:55:17.7985673Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspace'.
2024-11-15T01:55:17.8007418Z ##[debug]Importing cmdlet 'Get-PowerBIWorkspaceMigrationStatus'.
2024-11-15T01:55:17.8027484Z ##[debug]Importing cmdlet 'New-PowerBIWorkspace'.
2024-11-15T01:55:17.8043113Z ##[debug]Importing cmdlet 'Remove-PowerBIWorkspaceUser'.
2024-11-15T01:55:17.8067333Z ##[debug]Importing cmdlet 'Restore-PowerBIWorkspace'.
2024-11-15T01:55:17.8089761Z ##[debug]Importing cmdlet 'Set-PowerBIWorkspace'.
2024-11-15T01:55:17.8108756Z ##[debug]Importing alias 'Add-PowerBIGroupUser'.
2024-11-15T01:55:17.8112162Z ##[debug]Importing alias 'Get-PowerBIGroup'.
2024-11-15T01:55:17.8134917Z ##[debug]Importing alias 'Get-PowerBIGroupMigrationStatus'.
2024-11-15T01:55:17.8165673Z ##[debug]Importing alias 'New-PowerBIGroup'.
2024-11-15T01:55:17.8177869Z ##[debug]Importing alias 'Remove-PowerBIGroupUser'.
2024-11-15T01:55:17.8199018Z ##[debug]Importing alias 'Restore-PowerBIGroup'.
2024-11-15T01:55:17.8222884Z ##[debug]Importing alias 'Set-PowerBIGroup'.
2024-11-15T01:55:17.8244125Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077\MicrosoftPowerBIMgmt.Reports.psd1'.
2024-11-15T01:55:17.8312665Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Reports.
2024-11-15T01:55:17.8342256Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Reports\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Reports.dll'.
2024-11-15T01:55:17.8429313Z ##[debug]Exporting cmdlet 'Copy-PowerBIReport'.
2024-11-15T01:55:17.8448080Z ##[debug]Exporting cmdlet 'Copy-PowerBITile'.
2024-11-15T01:55:17.8469640Z ##[debug]Exporting cmdlet 'Export-PowerBIReport'.
2024-11-15T01:55:17.8487942Z ##[debug]Exporting cmdlet 'Get-PowerBIDashboard'.
2024-11-15T01:55:17.8506637Z ##[debug]Exporting cmdlet 'Get-PowerBIImport'.
2024-11-15T01:55:17.8556865Z ##[debug]Exporting cmdlet 'Get-PowerBIReport'.
2024-11-15T01:55:17.8589879Z ##[debug]Exporting cmdlet 'Get-PowerBITile'.
2024-11-15T01:55:17.8625833Z ##[debug]Exporting cmdlet 'New-PowerBIDashboard'.
2024-11-15T01:55:17.8651093Z ##[debug]Exporting cmdlet 'New-PowerBIReport'.
2024-11-15T01:55:17.8681823Z ##[debug]Exporting cmdlet 'Remove-PowerBIReport'.
2024-11-15T01:55:17.8704185Z ##[debug]Importing cmdlet 'Copy-PowerBIReport'.
2024-11-15T01:55:17.8725016Z ##[debug]Importing cmdlet 'Copy-PowerBITile'.
2024-11-15T01:55:17.8743247Z ##[debug]Importing cmdlet 'Export-PowerBIReport'.
2024-11-15T01:55:17.8763497Z ##[debug]Importing cmdlet 'Get-PowerBIDashboard'.
2024-11-15T01:55:17.8783922Z ##[debug]Importing cmdlet 'Get-PowerBIImport'.
2024-11-15T01:55:17.8803212Z ##[debug]Importing cmdlet 'Get-PowerBIReport'.
2024-11-15T01:55:17.8825731Z ##[debug]Importing cmdlet 'Get-PowerBITile'.
2024-11-15T01:55:17.8852082Z ##[debug]Importing cmdlet 'New-PowerBIDashboard'.
2024-11-15T01:55:17.8874089Z ##[debug]Importing cmdlet 'New-PowerBIReport'.
2024-11-15T01:55:17.8893872Z ##[debug]Importing cmdlet 'Remove-PowerBIReport'.
2024-11-15T01:55:17.8914963Z ##[debug]Importing alias 'Get-PowerBIDashboardTile'.
2024-11-15T01:55:17.9842213Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\MicrosoftPowerBIMgmt.Data.psd1'.
2024-11-15T01:55:17.9947481Z ##[debug]Loading 'FormatsToProcess' from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077\Microsoft.PowerBI.Commands.Data.format.ps1xml'.
2024-11-15T01:55:18.0289769Z ##[debug]Populating RepositorySourceLocation property for module MicrosoftPowerBIMgmt.Data.
2024-11-15T01:55:18.0321746Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\MicrosoftPowerBIMgmt.Data\1.2.1077.\lib\netstandard2.0\Microsoft.PowerBI.Commands.Data.dll'.
2024-11-15T01:55:18.0398264Z ##[debug]Exporting cmdlet 'Add-PowerBIDataset'.
2024-11-15T01:55:18.0418068Z ##[debug]Exporting cmdlet 'Add-PowerBIRow'.
2024-11-15T01:55:18.0440129Z ##[debug]Exporting cmdlet 'Export-PowerBIDataflow'.
2024-11-15T01:55:18.0458245Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflow'.
2024-11-15T01:55:18.0478452Z ##[debug]Exporting cmdlet 'Get-PowerBIDataflowDatasource'.
2024-11-15T01:55:18.0498872Z ##[debug]Exporting cmdlet 'Get-PowerBIDataset'.
2024-11-15T01:55:18.0519723Z ##[debug]Exporting cmdlet 'Get-PowerBIDatasource'.
2024-11-15T01:55:18.0539542Z ##[debug]Exporting cmdlet 'Get-PowerBITable'.
2024-11-15T01:55:18.0558140Z ##[debug]Exporting cmdlet 'New-PowerBIColumn'.
2024-11-15T01:55:18.0577806Z ##[debug]Exporting cmdlet 'New-PowerBIDataset'.
2024-11-15T01:55:18.0605029Z ##[debug]Exporting cmdlet 'New-PowerBITable'.
2024-11-15T01:55:18.0626732Z ##[debug]Exporting cmdlet 'Remove-PowerBIRow'.
2024-11-15T01:55:18.0647076Z ##[debug]Exporting cmdlet 'Set-PowerBIDataset'.
2024-11-15T01:55:18.0665592Z ##[debug]Exporting cmdlet 'Set-PowerBITable'.
2024-11-15T01:55:18.0687480Z ##[debug]Importing cmdlet 'Add-PowerBIDataset'.
2024-11-15T01:55:18.0724545Z ##[debug]Importing cmdlet 'Add-PowerBIRow'.
2024-11-15T01:55:18.0734737Z ##[debug]Importing cmdlet 'Export-PowerBIDataflow'.
2024-11-15T01:55:18.0748719Z ##[debug]Importing cmdlet 'Get-PowerBIDataflow'.
2024-11-15T01:55:18.0768272Z ##[debug]Importing cmdlet 'Get-PowerBIDataflowDatasource'.
2024-11-15T01:55:18.0786893Z ##[debug]Importing cmdlet 'Get-PowerBIDataset'.
2024-11-15T01:55:18.0806017Z ##[debug]Importing cmdlet 'Get-PowerBIDatasource'.
2024-11-15T01:55:18.0825300Z ##[debug]Importing cmdlet 'Get-PowerBITable'.
2024-11-15T01:55:18.0842206Z ##[debug]Importing cmdlet 'New-PowerBIColumn'.
2024-11-15T01:55:18.0865989Z ##[debug]Importing cmdlet 'New-PowerBIDataset'.
2024-11-15T01:55:18.0893228Z ##[debug]Importing cmdlet 'New-PowerBITable'.
2024-11-15T01:55:18.0913353Z ##[debug]Importing cmdlet 'Remove-PowerBIRow'.
2024-11-15T01:55:18.0925370Z ##[debug]Importing cmdlet 'Set-PowerBIDataset'.
2024-11-15T01:55:18.0942419Z ##[debug]Importing cmdlet 'Set-PowerBITable'.
2024-11-15T01:55:18.0954285Z ### Trying to import the incorporated module for PowerBI
2024-11-15T01:55:18.0979596Z ##[debug]Loading module from path 'D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1'.
2024-11-15T01:55:18.2145646Z ##[debug]Exporting function 'Set-PowerBIDatasetToGatewayInGroup'.
2024-11-15T01:55:18.2163828Z ##[debug]Exporting function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2024-11-15T01:55:18.2185820Z ##[debug]Exporting function 'Update-PowerBIDatasetSource'.
2024-11-15T01:55:18.2204509Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasourcesInGroup'.
2024-11-15T01:55:18.2224972Z ##[debug]Exporting function 'Get-PowerBIDataSourcesInGateway'.
2024-11-15T01:55:18.2243460Z ##[debug]Exporting function 'Get-PowerBIGateways'.
2024-11-15T01:55:18.2262805Z ##[debug]Exporting function 'Set-DatasetOwnership'.
2024-11-15T01:55:18.2281209Z ##[debug]Exporting function 'Set-PowerBIDataSetOwnership'.
2024-11-15T01:55:18.2298530Z ##[debug]Exporting function 'Update-PowerBIDatasetParameter'.
2024-11-15T01:55:18.2318394Z ##[debug]Exporting function 'Update-PowerBIDatasetParameters'.
2024-11-15T01:55:18.2339582Z ##[debug]Exporting function 'Invoke-API'.
2024-11-15T01:55:18.2359395Z ##[debug]Exporting function 'New-DataSetSingleRefresh'.
2024-11-15T01:55:18.2377550Z ##[debug]Exporting function 'New-DatasetRefresh'.
2024-11-15T01:55:18.2397236Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasources'.
2024-11-15T01:55:18.2417947Z ##[debug]Exporting function 'Update-PowerBIDatasetDatasource'.
2024-11-15T01:55:18.2435709Z ##[debug]Exporting function 'Update-ConnectionStringDirectQuery'.
2024-11-15T01:55:18.2456133Z ##[debug]Exporting function 'Get-PowerBIReport'.
2024-11-15T01:55:18.2475442Z ##[debug]Exporting function 'Get-PowerBiDataSet'.
2024-11-15T01:55:18.2498002Z ##[debug]Exporting function 'Get-PowerBiDataSetDataSources'.
2024-11-15T01:55:18.2518843Z ##[debug]Exporting function 'Get-PowerBiDataSets'.
2024-11-15T01:55:18.2538661Z ##[debug]Exporting function 'Get-PowerBiParameters'.
2024-11-15T01:55:18.2559598Z ##[debug]Exporting function 'New-PowerBIWorkSpace'.
2024-11-15T01:55:18.2577502Z ##[debug]Exporting function 'Remove-PowerBIWorkSpace'.
2024-11-15T01:55:18.2597391Z ##[debug]Exporting function 'Import-PowerBIFile'.
2024-11-15T01:55:18.2616228Z ##[debug]Exporting function 'Get-PowerBIGroupPath'.
2024-11-15T01:55:18.2635717Z ##[debug]Exporting function 'Add-PowerBIWorkspaceUsers'.
2024-11-15T01:55:18.2656379Z ##[debug]Exporting function 'Add-PowerBIWorkspaceGroup'.
2024-11-15T01:55:18.2675756Z ##[debug]Exporting function 'Add-PowerBIWorkspaceSP'.
2024-11-15T01:55:18.2695441Z ##[debug]Exporting function 'Publish-PowerBIFile'.
2024-11-15T01:55:18.2714527Z ##[debug]Exporting function 'Publish-PowerBIFileApi'.
2024-11-15T01:55:18.2757028Z ##[debug]Exporting function 'Remove-PowerBIReport'.
2024-11-15T01:55:18.2774964Z ##[debug]Exporting function 'Get-PowerBICapacity'.
2024-11-15T01:55:18.2783331Z ##[debug]Exporting function 'Set-Capacity'.
2024-11-15T01:55:18.2804332Z ##[debug]Exporting function 'Redo-PowerBIReport'.
2024-11-15T01:55:18.2822975Z ##[debug]Exporting function 'Redo-PowerBIReportCrossWorkspace'.
2024-11-15T01:55:18.2842380Z ##[debug]Exporting function 'Update-BasicSQLDataSourceCredentials'.
2024-11-15T01:55:18.2862806Z ##[debug]Exporting function 'Set-RefreshSchedule'.
2024-11-15T01:55:18.2881226Z ##[debug]Exporting function 'Publish-TabularEditor'.
2024-11-15T01:55:18.2899660Z ##[debug]Exporting function 'Add-PowerBIDatasetPermissions'.
2024-11-15T01:55:18.2918035Z ##[debug]Exporting function 'Get-PowerBiDatasetUsers'.
2024-11-15T01:55:18.2938190Z ##[debug]Exporting function 'Set-PowerBIDatasourceCredentials'.
2024-11-15T01:55:18.2957190Z ##[debug]Exporting function 'Update-DatasourceCredentialsInGateway'.
2024-11-15T01:55:18.2981043Z ##[debug]Importing function 'Add-PowerBIDatasetPermissions'.
2024-11-15T01:55:18.2998945Z ##[debug]Importing function 'Add-PowerBIWorkspaceGroup'.
2024-11-15T01:55:18.3017867Z ##[debug]Importing function 'Add-PowerBIWorkspaceSP'.
2024-11-15T01:55:18.3037167Z ##[debug]Importing function 'Add-PowerBIWorkspaceUsers'.
2024-11-15T01:55:18.3057383Z ##[debug]Importing function 'Get-PowerBICapacity'.
2024-11-15T01:55:18.3075807Z ##[debug]Importing function 'Get-PowerBiDataSet'.
2024-11-15T01:55:18.3092689Z ##[debug]Importing function 'Get-PowerBiDataSetDataSources'.
2024-11-15T01:55:18.3111838Z ##[debug]Importing function 'Get-PowerBIDatasetGatewayDatasourceInGroup'.
2024-11-15T01:55:18.3131073Z ##[debug]Importing function 'Get-PowerBiDataSets'.
2024-11-15T01:55:18.3148476Z ##[debug]Importing function 'Get-PowerBiDatasetUsers'.
2024-11-15T01:55:18.3165813Z ##[debug]Importing function 'Get-PowerBIDataSourcesInGateway'.
2024-11-15T01:55:18.3182251Z ##[debug]Importing function 'Get-PowerBIGateways'.
2024-11-15T01:55:18.3200207Z ##[debug]Importing function 'Get-PowerBIGroupPath'.
2024-11-15T01:55:18.3217611Z ##[debug]Importing function 'Get-PowerBiParameters'.
2024-11-15T01:55:18.3236223Z ##[debug]Importing function 'Get-PowerBIReport'.
2024-11-15T01:55:18.3254554Z ##[debug]Importing function 'Import-PowerBIFile'.
2024-11-15T01:55:18.3271361Z ##[debug]Importing function 'Invoke-API'.
2024-11-15T01:55:18.3290662Z ##[debug]Importing function 'New-DatasetRefresh'.
2024-11-15T01:55:18.3310119Z ##[debug]Importing function 'New-DataSetSingleRefresh'.
2024-11-15T01:55:18.3331955Z ##[debug]Importing function 'New-PowerBIWorkSpace'.
2024-11-15T01:55:18.3349789Z ##[debug]Importing function 'Publish-PowerBIFile'.
2024-11-15T01:55:18.3368522Z ##[debug]Importing function 'Publish-PowerBIFileApi'.
2024-11-15T01:55:18.3384538Z ##[debug]Importing function 'Publish-TabularEditor'.
2024-11-15T01:55:18.3401721Z ##[debug]Importing function 'Redo-PowerBIReport'.
2024-11-15T01:55:18.3435324Z ##[debug]Importing function 'Redo-PowerBIReportCrossWorkspace'.
2024-11-15T01:55:18.3459064Z ##[debug]Importing function 'Remove-PowerBIReport'.
2024-11-15T01:55:18.3477411Z ##[debug]Importing function 'Remove-PowerBIWorkSpace'.
2024-11-15T01:55:18.3495464Z ##[debug]Importing function 'Set-Capacity'.
2024-11-15T01:55:18.3514182Z ##[debug]Importing function 'Set-DatasetOwnership'.
2024-11-15T01:55:18.3534135Z ##[debug]Importing function 'Set-PowerBIDataSetOwnership'.
2024-11-15T01:55:18.3553197Z ##[debug]Importing function 'Set-PowerBIDatasetToGatewayInGroup'.
2024-11-15T01:55:18.3572990Z ##[debug]Importing function 'Set-PowerBIDatasourceCredentials'.
2024-11-15T01:55:18.3588892Z ##[debug]Importing function 'Set-RefreshSchedule'.
2024-11-15T01:55:18.3612293Z ##[debug]Importing function 'Update-BasicSQLDataSourceCredentials'.
2024-11-15T01:55:18.3629730Z ##[debug]Importing function 'Update-ConnectionStringDirectQuery'.
2024-11-15T01:55:18.3649273Z ##[debug]Importing function 'Update-DatasourceCredentialsInGateway'.
2024-11-15T01:55:18.3667667Z ##[debug]Importing function 'Update-PowerBIDatasetDatasource'.
2024-11-15T01:55:18.3687134Z ##[debug]Importing function 'Update-PowerBIDatasetDatasources'.
2024-11-15T01:55:18.3706879Z ##[debug]Importing function 'Update-PowerBIDatasetDatasourcesInGroup'.
2024-11-15T01:55:18.3724693Z ##[debug]Importing function 'Update-PowerBIDatasetParameter'.
2024-11-15T01:55:18.3745444Z ##[debug]Importing function 'Update-PowerBIDatasetParameters'.
2024-11-15T01:55:18.3768058Z ##[debug]Importing function 'Update-PowerBIDatasetSource'.
2024-11-15T01:55:18.4128158Z ##[debug]INPUT_POWERBISERVICEENDPOINT: '235bbd85-cd97-4572-829f-8c873ba91c9d'
2024-11-15T01:55:18.4266630Z ##[debug]ENDPOINT_URL_235bbd85-cd97-4572-829f-8c873ba91c9d: 'https://api.powerbi.com/v1.0/myorg'
2024-11-15T01:55:18.4290469Z ##[debug]ENDPOINT_AUTH_235bbd85-cd97-4572-829f-8c873ba91c9d: '**'
2024-11-15T01:55:18.4318601Z ##[debug]ENDPOINT_DATA_235bbd85-cd97-4572-829f-8c873ba91c9d: '{"OrganizationType":"Public"}'
2024-11-15T01:55:18.6878346Z ##[debug]{
2024-11-15T01:55:18.6892028Z ##[debug] "Url": "https://api.powerbi.com/v1.0/myorg",
2024-11-15T01:55:18.6906858Z ##[debug] "Data": {
2024-11-15T01:55:18.6920496Z ##[debug] "OrganizationType": "Public"
2024-11-15T01:55:18.6935030Z ##[debug] },
2024-11-15T01:55:18.6948280Z ##[debug] "Auth": {
2024-11-15T01:55:18.6963545Z ##[debug] "parameters": {
2024-11-15T01:55:18.6978690Z ##[debug] "TenantId": "
",
2024-11-15T01:55:18.6992085Z ##[debug] "ClientId": "
",
2024-11-15T01:55:18.7006260Z ##[debug] "ClientCertificate": "",
2024-11-15T01:55:18.7019233Z ##[debug] "ClientSecret": ***
2024-11-15T01:55:18.7031466Z ##[debug] },
2024-11-15T01:55:18.7044754Z ##[debug] "scheme": "None"
2024-11-15T01:55:18.7059462Z ##[debug] }
2024-11-15T01:55:18.7075299Z ##[debug]}
2024-11-15T01:55:19.3521404Z ##[debug]1:55:19 AM - Connect-PowerBIServiceAccount begin processing with ParameterSet ServicePrincipal.
2024-11-15T01:55:19.3545092Z ##[debug]1:55:19 AM - Cmdlet version: 1.2.1077.0
2024-11-15T01:55:19.3909011Z ##[debug]Updated Azure AD authority with -Tenant specified, new value: https://login.microsoftonline.com/94260f03-0793-484a-91cf-bebe584319bc
2024-11-15T01:55:19.5792243Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19] Found 0 cache accounts and 0 broker accounts
2024-11-15T01:55:19.5875303Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(9b54c14f-1fe5-4aba-a474-ba8316ffbb54)
2024-11-15T01:55:19.5910082Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] === AcquireTokenForClientParameters ===
2024-11-15T01:55:19.5926439Z ##[debug]SendX5C: False
2024-11-15T01:55:19.5940177Z ##[debug]WithAzureRegion: False
2024-11-15T01:55:19.5956555Z ##[debug]RegionToUse:
2024-11-15T01:55:19.5974773Z ##[debug]ForceRefresh: False
2024-11-15T01:55:19.5989787Z ##[debug]
2024-11-15T01:55:19.6136912Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54]
2024-11-15T01:55:19.6151077Z ##[debug]=== Request Data ===
2024-11-15T01:55:19.6165255Z ##[debug]Authority Provided? - True
2024-11-15T01:55:19.6179818Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-15T01:55:19.6192942Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-15T01:55:19.6207219Z ##[debug]ApiId - AcquireTokenForClient
2024-11-15T01:55:19.6223324Z ##[debug]IsConfidentialClient - True
2024-11-15T01:55:19.6236823Z ##[debug]SendX5C - False
2024-11-15T01:55:19.6251566Z ##[debug]LoginHint ? False
2024-11-15T01:55:19.6266907Z ##[debug]IsBrokerConfigured - False
2024-11-15T01:55:19.6283191Z ##[debug]HomeAccountId - False
2024-11-15T01:55:19.6296234Z ##[debug]CorrelationId - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54
2024-11-15T01:55:19.6310372Z ##[debug]
2024-11-15T01:55:19.6342425Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] === Token Acquisition (ClientCredentialRequest) started:
2024-11-15T01:55:19.6356698Z ##[debug]
2024-11-15T01:55:19.6370683Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-15T01:55:19.6745706Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:19 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Fetching instance discovery from the network from host login.microsoftonline.com.
2024-11-15T01:55:20.1932953Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Resolving authority endpoints... Already resolved? - FALSE
2024-11-15T01:55:20.1953498Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] ScopeSet was missing from the token response, so using developer provided scopes in the result.
2024-11-15T01:55:20.1974109Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Checking client info returned from the server..
2024-11-15T01:55:20.1998184Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Saving Token Response to cache..
2024-11-15T01:55:20.2019418Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] ID Token not present in response.
2024-11-15T01:55:20.2070414Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Saving AT in cache and removing overlapping ATs...
2024-11-15T01:55:20.2071910Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Looking for scopes for the authority in the cache which intersect with https://analysis.windows.net/powerbi/api/.default
2024-11-15T01:55:20.2088584Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] Intersecting scope entries count - 0
2024-11-15T01:55:20.2097345Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - 9b54c14f-1fe5-4aba-a474-ba8316ffbb54] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 ===
2024-11-15T01:55:20.2118855Z ##[debug]1:55:20 AM - Connect-PowerBIServiceAccount end processing.
2024-11-15T01:55:20.2149999Z ##[debug]INPUT_POWERBIPATH: 'D:\a\1\report\report.pbix'
2024-11-15T01:55:20.2482838Z ##[debug]INPUT_WORKSPACENAME: 'dev'
2024-11-15T01:55:20.2507576Z ##[debug]INPUT_OVERWRITE: 'true'
2024-11-15T01:55:20.2550256Z ##[debug] Converted to bool: True
2024-11-15T01:55:20.2576347Z ##[debug]INPUT_CREATE: 'false'
2024-11-15T01:55:20.2597902Z ##[debug] Converted to bool: False
2024-11-15T01:55:20.2627401Z ##[debug]INPUT_ACTION: 'Publish'
2024-11-15T01:55:20.2652689Z ##[debug]INPUT_DATASETNAME (empty)
2024-11-15T01:55:20.2703996Z ##[debug]INPUT_OLDURL (empty)
2024-11-15T01:55:20.2730108Z ##[debug]INPUT_NEWURL (empty)
2024-11-15T01:55:20.2756410Z ##[debug]INPUT_OLDSERVER (empty)
2024-11-15T01:55:20.2788094Z ##[debug]INPUT_NEWSERVER (empty)
2024-11-15T01:55:20.2815038Z ##[debug]INPUT_OLDDATABASE (empty)
2024-11-15T01:55:20.2842418Z ##[debug]INPUT_GROUPOBJECTIDS (empty)
2024-11-15T01:55:20.2869607Z ##[debug]INPUT_NEWDATABASE (empty)
2024-11-15T01:55:20.2898698Z ##[debug]INPUT_PERMISSION (empty)
2024-11-15T01:55:20.2925028Z ##[debug]INPUT_USERS (empty)
2024-11-15T01:55:20.2952989Z ##[debug]INPUT_DATASOURCETYPE: 'Sql'
2024-11-15T01:55:20.2980374Z ##[debug]INPUT_UPDATEALL: 'false'
2024-11-15T01:55:20.3002843Z ##[debug] Converted to bool: False
2024-11-15T01:55:20.3029150Z ##[debug]INPUT_SKIPREPORT: 'false'
2024-11-15T01:55:20.3049217Z ##[debug] Converted to bool: False
2024-11-15T01:55:20.3075760Z ##[debug]INPUT_SCOPE: 'Private'
2024-11-15T01:55:20.3105273Z ##[debug]INPUT_SERVICEPRINCIPALS (empty)
2024-11-15T01:55:20.3130182Z ##[debug]INPUT_CONNECTIONSTRING (empty)
2024-11-15T01:55:20.3156558Z ##[debug]INPUT_PARAMETERINPUT (empty)
2024-11-15T01:55:20.3183338Z ##[debug]INPUT_GATEWAYNAME (empty)
2024-11-15T01:55:20.3210543Z ##[debug]INPUT_REPORTNAME (empty)
2024-11-15T01:55:20.3237035Z ##[debug]INPUT_CAPACITYNAME (empty)
2024-11-15T01:55:20.3264356Z ##[debug]INPUT_USERNAME (empty)
2024-11-15T01:55:20.3291022Z ##[debug]INPUT_PASSWORD (empty)
2024-11-15T01:55:20.4129828Z ##[debug]INPUT_REFRESHSCHEDULEINPUT (empty)
2024-11-15T01:55:20.4132092Z ##[debug]INPUT_CROSSWORKSPACEREBINDING: 'false'
2024-11-15T01:55:20.4164766Z ##[debug] Converted to bool: False
2024-11-15T01:55:20.4189798Z ##[debug]INPUT_REPORTWORKSPACENAME (empty)
2024-11-15T01:55:20.4282266Z ##[debug]INPUT_TABULAREDITORARGUMENTS (empty)
2024-11-15T01:55:20.4307355Z ##[debug]INPUT_PRINCIPALTYPE: 'User'
2024-11-15T01:55:20.4332763Z ##[debug]INPUT_DATASETPERMISSIONSUSERS (empty)
2024-11-15T01:55:20.4355521Z ##[debug]INPUT_DATASETPERMISSIONSGROUPOBJECTIDS (empty)
2024-11-15T01:55:20.4381069Z ##[debug]INPUT_DATASETACCESSRIGHT (empty)
2024-11-15T01:55:20.4403829Z ##[debug]INPUT_SERVER (empty)
2024-11-15T01:55:20.4428648Z ##[debug]INPUT_DATABASE (empty)
2024-11-15T01:55:20.4451247Z ##[debug]INPUT_TENANTID (empty)
2024-11-15T01:55:20.4474706Z ##[debug]INPUT_SERVICEPRINCIPALID (empty)
2024-11-15T01:55:20.4477670Z ##[debug]INPUT_SERVICEPRINCIPALKEY (empty)
2024-11-15T01:55:20.4506042Z ##[debug]WorkspaceName : dev
2024-11-15T01:55:20.4528144Z ##[debug]Create : False
2024-11-15T01:55:20.4547124Z ##[debug]File patern : D:\a\1\report\report.pbix
2024-11-15T01:55:20.4567386Z ##[debug]Remove report : False
2024-11-15T01:55:20.4754403Z Getting Power BI Workspace properties; dev
2024-11-15T01:55:20.4816047Z ##[debug]1:55:20 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2024-11-15T01:55:20.4840714Z ##[debug]1:55:20 AM - Cmdlet version: 1.2.1077.0
2024-11-15T01:55:20.5494695Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20] Found 0 cache accounts and 0 broker accounts
2024-11-15T01:55:20.5516138Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(c64b1495-61d0-4b14-a0f0-06f124f8e3ea)
2024-11-15T01:55:20.5537060Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] === AcquireTokenForClientParameters ===
2024-11-15T01:55:20.5551471Z ##[debug]SendX5C: False
2024-11-15T01:55:20.5565864Z ##[debug]WithAzureRegion: False
2024-11-15T01:55:20.5580800Z ##[debug]RegionToUse:
2024-11-15T01:55:20.5594349Z ##[debug]ForceRefresh: False
2024-11-15T01:55:20.5609162Z ##[debug]
2024-11-15T01:55:20.5631448Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea]
2024-11-15T01:55:20.5646141Z ##[debug]=== Request Data ===
2024-11-15T01:55:20.5660303Z ##[debug]Authority Provided? - True
2024-11-15T01:55:20.5676181Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-15T01:55:20.5692682Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-15T01:55:20.5707698Z ##[debug]ApiId - AcquireTokenForClient
2024-11-15T01:55:20.5722948Z ##[debug]IsConfidentialClient - True
2024-11-15T01:55:20.5739477Z ##[debug]SendX5C - False
2024-11-15T01:55:20.5754033Z ##[debug]LoginHint ? False
2024-11-15T01:55:20.5771443Z ##[debug]IsBrokerConfigured - False
2024-11-15T01:55:20.5797484Z ##[debug]HomeAccountId - False
2024-11-15T01:55:20.5816008Z ##[debug]CorrelationId - c64b1495-61d0-4b14-a0f0-06f124f8e3ea
2024-11-15T01:55:20.5828848Z ##[debug]
2024-11-15T01:55:20.5853416Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] === Token Acquisition (ClientCredentialRequest) started:
2024-11-15T01:55:20.5867580Z ##[debug]
2024-11-15T01:55:20.5882582Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-15T01:55:20.5948647Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] Access token is not expired. Returning the found cache entry. [Current time (11/15/2024 01:55:20) - Expiration Time (11/15/2024 02:55:19 +00:00) - Extended Expiration Time (11/15/2024 02:55:19 +00:00)]
2024-11-15T01:55:20.5979048Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:20 - c64b1495-61d0-4b14-a0f0-06f124f8e3ea] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 ===
2024-11-15T01:55:21.6535713Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'dev'&$top=100
2024-11-15T01:55:21.6552917Z ##[debug]Status Code: OK (200)
2024-11-15T01:55:21.6574071Z ##[debug]1:55:21 AM - Get-PowerBIWorkspace end processing.
2024-11-15T01:55:21.6641285Z ##[debug]Processed: ##vso[task.setvariable variable=PowerBIActions.WorkspaceId]b13833a5-3cff-4582-9c20-b1898fa06718
2024-11-15T01:55:21.6664333Z ##[debug]1:55:21 AM - Get-PowerBIWorkspace begin processing with ParameterSet Name.
2024-11-15T01:55:21.6717098Z ##[debug]1:55:21 AM - Cmdlet version: 1.2.1077.0
2024-11-15T01:55:21.6738571Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21] Found 0 cache accounts and 0 broker accounts
2024-11-15T01:55:21.6757530Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(3429cdfc-05d3-4186-bc63-2baad82254d2)
2024-11-15T01:55:21.6780011Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] === AcquireTokenForClientParameters ===
2024-11-15T01:55:21.6793288Z ##[debug]SendX5C: False
2024-11-15T01:55:21.6805683Z ##[debug]WithAzureRegion: False
2024-11-15T01:55:21.6821593Z ##[debug]RegionToUse:
2024-11-15T01:55:21.6837624Z ##[debug]ForceRefresh: False
2024-11-15T01:55:21.6850325Z ##[debug]
2024-11-15T01:55:21.6871071Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2]
2024-11-15T01:55:21.6887225Z ##[debug]=== Request Data ===
2024-11-15T01:55:21.6899048Z ##[debug]Authority Provided? - True
2024-11-15T01:55:21.6911112Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-15T01:55:21.6925825Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-15T01:55:21.6939260Z ##[debug]ApiId - AcquireTokenForClient
2024-11-15T01:55:21.6951789Z ##[debug]IsConfidentialClient - True
2024-11-15T01:55:21.6965161Z ##[debug]SendX5C - False
2024-11-15T01:55:21.6980686Z ##[debug]LoginHint ? False
2024-11-15T01:55:21.6995927Z ##[debug]IsBrokerConfigured - False
2024-11-15T01:55:21.7008414Z ##[debug]HomeAccountId - False
2024-11-15T01:55:21.7020449Z ##[debug]Agent environment resources - Disk: D:\ Available 12446.73 MB out of 14334.00 MB, Memory: Used 2087.00 MB out of 7167.00 MB, CPU: Usage 75.00%
2024-11-15T01:55:21.7031960Z ##[debug]CorrelationId - 3429cdfc-05d3-4186-bc63-2baad82254d2
2024-11-15T01:55:21.7033731Z ##[debug]
2024-11-15T01:55:21.7052336Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] === Token Acquisition (ClientCredentialRequest) started:
2024-11-15T01:55:21.7065560Z ##[debug]
2024-11-15T01:55:21.7081667Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-15T01:55:21.7102071Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] Access token is not expired. Returning the found cache entry. [Current time (11/15/2024 01:55:21) - Expiration Time (11/15/2024 02:55:19 +00:00) - Extended Expiration Time (11/15/2024 02:55:19 +00:00)]
2024-11-15T01:55:21.7121468Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:21 - 3429cdfc-05d3-4186-bc63-2baad82254d2] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 ===
2024-11-15T01:55:22.3035338Z ##[debug]Request Uri: https://api.powerbi.com/v1.0/myorg/groups?$filter=tolower(name) eq 'dev'&$top=100
2024-11-15T01:55:22.3053075Z ##[debug]Status Code: OK (200)
2024-11-15T01:55:22.3071716Z ##[debug]1:55:22 AM - Get-PowerBIWorkspace end processing.
2024-11-15T01:55:22.3150747Z Trying to publish PowerBI File: D:\a\1\report\report.pbix
2024-11-15T01:55:22.3199996Z Checking for existing Reports with the name: report
2024-11-15T01:55:22.3280813Z ##[debug]1:55:22 AM - New-PowerBIReport begin processing with ParameterSet Workspace.
2024-11-15T01:55:22.3302014Z ##[debug]1:55:22 AM - Cmdlet version: 1.2.1077.0
2024-11-15T01:55:22.3335050Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22] Found 0 cache accounts and 0 broker accounts
2024-11-15T01:55:22.3356635Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] MSAL MSAL.Desktop with assembly version '4.25.0.0'. CorrelationId(4160b268-0023-4fb2-8c12-810119ac372b)
2024-11-15T01:55:22.3380170Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] === AcquireTokenForClientParameters ===
2024-11-15T01:55:22.3394023Z ##[debug]SendX5C: False
2024-11-15T01:55:22.3407360Z ##[debug]WithAzureRegion: False
2024-11-15T01:55:22.3420860Z ##[debug]RegionToUse:
2024-11-15T01:55:22.3436741Z ##[debug]ForceRefresh: False
2024-11-15T01:55:22.3451044Z ##[debug]
2024-11-15T01:55:22.3473946Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b]
2024-11-15T01:55:22.3489964Z ##[debug]=== Request Data ===
2024-11-15T01:55:22.3506083Z ##[debug]Authority Provided? - True
2024-11-15T01:55:22.3522304Z ##[debug]Scopes - https://analysis.windows.net/powerbi/api/.default
2024-11-15T01:55:22.4209265Z ##[debug]Extra Query Params Keys (space separated) -
2024-11-15T01:55:22.4225326Z ##[debug]ApiId - AcquireTokenForClient
2024-11-15T01:55:22.4242734Z ##[debug]IsConfidentialClient - True
2024-11-15T01:55:22.4255711Z ##[debug]SendX5C - False
2024-11-15T01:55:22.4269766Z ##[debug]LoginHint ? False
2024-11-15T01:55:22.4284808Z ##[debug]IsBrokerConfigured - False
2024-11-15T01:55:22.4300481Z ##[debug]HomeAccountId - False
2024-11-15T01:55:22.4314078Z ##[debug]CorrelationId - 4160b268-0023-4fb2-8c12-810119ac372b
2024-11-15T01:55:22.4328685Z ##[debug]
2024-11-15T01:55:22.4350845Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] === Token Acquisition (ClientCredentialRequest) started:
2024-11-15T01:55:22.4364218Z ##[debug]
2024-11-15T01:55:22.4377028Z ##[debug] Authority Host: login.microsoftonline.com
2024-11-15T01:55:22.4401480Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] Access token is not expired. Returning the found cache entry. [Current time (11/15/2024 01:55:22) - Expiration Time (11/15/2024 02:55:19 +00:00) - Extended Expiration Time (11/15/2024 02:55:19 +00:00)]
2024-11-15T01:55:22.4420307Z ##debug MSAL 4.25.0.0 MSAL.Desktop Microsoft Windows NT 10.0.20348.0 [11/15/2024 01:55:22 - 4160b268-0023-4fb2-8c12-810119ac372b] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 11/15/2024 02:55:19 +00:00 ===
2024-11-15T01:55:23.2355104Z Done processing Power BI Actions
2024-11-15T01:55:23.2994693Z ##[debug]Caught exception from task script.
2024-11-15T01:55:23.3031870Z ##[debug]Error record:
2024-11-15T01:55:23.3658323Z ##[debug]New-PowerBIReport : Operation returned an invalid status code 'BadRequest'
2024-11-15T01:55:23.3675844Z ##[debug]At D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1:797 char:27
2024-11-15T01:55:23.3690565Z ##[debug]+ ... $report = New-PowerBIReport -Path $filePath -Name $fileToPublish -W ...
2024-11-15T01:55:23.3704440Z ##[debug]+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2024-11-15T01:55:23.3721123Z ##[debug] + CategoryInfo : WriteError: (Microsoft.Power...ewPowerBIReport:NewPowerBIReport) [New-PowerBIReport], Ht tpOperationException
2024-11-15T01:55:23.3735457Z ##[debug] + FullyQualifiedErrorId : Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Report s.NewPowerBIReport
2024-11-15T01:55:23.3748945Z ##[debug]
2024-11-15T01:55:23.3770476Z ##[debug]Script stack trace:
2024-11-15T01:55:23.3820819Z ##[debug]at Publish-PowerBIFile, D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\ps_modules\PowerBI\PowerBI.psm1: line 797
2024-11-15T01:55:23.3838760Z ##[debug]at , D:\a_tasks\PowerBIActions_d5b7fec6-2b25-4742-905b-0dad97687df5\5.4.54\run.ps1: line 117
2024-11-15T01:55:23.3856665Z ##[debug]at , : line 1
2024-11-15T01:55:23.3871233Z ##[debug]at , : line 22
2024-11-15T01:55:23.3885528Z ##[debug]at , : line 18
2024-11-15T01:55:23.3901084Z ##[debug]at , : line 1
2024-11-15T01:55:23.3924890Z ##[debug]Exception:
2024-11-15T01:55:23.4157588Z ##[debug]Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'BadRequest'
2024-11-15T01:55:23.4173079Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d__8.MoveNext()
2024-11-15T01:55:23.4188730Z ##[debug]--- End of stack trace from previous location where exception was thrown ---
2024-11-15T01:55:23.4201927Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
2024-11-15T01:55:23.4217037Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
2024-11-15T01:55:23.4232149Z ##[debug] at Microsoft.PowerBI.Api.V2.Imports.d__7.MoveNext()
2024-11-15T01:55:23.4246148Z ##[debug]--- End of stack trace from previous location where exception was thrown ---
2024-11-15T01:55:23.4259347Z ##[debug] at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
2024-11-15T01:55:23.4273554Z ##[debug] at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
2024-11-15T01:55:23.4288278Z ##[debug] at Microsoft.PowerBI.Api.V2.ImportsExtensions.PostImportWithFileInGroup(IImports operations, String groupId, Stream fileStream, String datasetDisplayName, String nameConflict, Nullable`1 skipReport)
2024-11-15T01:55:23.4304243Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostImportForWorkspace(Guid workspaceId, String datasetDisplayName, String filePath, ImportConflictHandlerModeEnum nameConflict)
2024-11-15T01:55:23.4320130Z ##[debug] at Microsoft.PowerBI.Common.Api.Reports.ReportsClient.PostReportForWorkspace(Guid workspaceId, String reportName, String filePath, ImportConflictHandlerModeEnum nameConflict, Int32 timeout)
2024-11-15T01:55:23.4333744Z ##[debug] at Microsoft.PowerBI.Commands.Reports.NewPowerBIReport.ExecuteCmdlet()
2024-11-15T01:55:23.4346666Z ##[debug] at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord()
2024-11-15T01:55:23.4620221Z ##[error]Operation returned an invalid status code 'BadRequest'
2024-11-15T01:55:23.4628799Z ##[debug]Processed: ##vso[task.logissue type=error]Operation returned an invalid status code 'BadRequest'
2024-11-15T01:55:23.4638014Z ##[debug]Processed: ##vso[task.complete result=Failed]
2024-11-15T01:55:23.4943287Z ##[section]Finishing: Publish PowerBI Report

@lukelic
Copy link

lukelic commented Nov 21, 2024

🤦 The PowerBI report wasn't being checked out properly with git-lfs.

Added:

    - checkout: self
      lfs: true

To the packaging step and I'm able to publish the report.

@lukelic
Copy link

lukelic commented Nov 21, 2024

This can be closed.

@maikvandergaag
Copy link
Owner

Good to hear

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants