Excel Report Fails to Generate

[discmixr]

Is Excel required to generate the Excel formatted output? Office is something not typically installed into an Azure AD environment.

Is there an accepted process to run this from a workstation remotely that would have the necessary prerequisites installed?

Here are examples of the command switches used with no effect:

PS C:\azucar-master> .\Azucar.ps1 -ExportTo EXCEL,CSV,XML,JSON -Verbose -Instance AzureCloud -Analysis ALL PS C:\azucar-master> .\Azucar.ps1 -ExportTo EXCEL -Verbose -Instance AzureCloud -Analysis ALL PS C:\azucar-master> .\Azucar.ps1 -ExportTo EXCEL -Verbose -Analysis ALL PS C:\azucar-master> .\Azucar.ps1 -ExportTo EXCEL -Verbose Please find attached a image of the errors

We did collect data in the CSV Report, JSON Report, and XML Reports for Active directory and security. Is there any way to convert these source files into the Excel output running one of the other subordinate PS scripts within azucar?

Many Thanks in Advance for your time and effort! -Bob

[discmixr]

Update to Prior Post - Many Thanks in Advance for your help!!

With MS Excel Installed on WS - Executed these first:

PS C:\azucar-master> set-executionpolicy remotesigned PS C:\azucar-master> get-help .\Azucar.ps1 - TO Update PS C:\azucar-master> Install-Module -Name Az -AllowClobber PS C:\azucar-master> $psversiontable - TO Verify PS C:\azucar-master> Add-AzureAccount

Running the PS as global administrator on workstation remotely:

PS C:\azucar-master> .\Azucar.ps1 -Authmode Client_Credentials -TenantID ad3b1983-bb28-4abd-b3c8-e2cda805XXXX -ExportTo EXCEL -Verbose -Instance AzureCloud -Analysis ALL

VERBOSE: [10:11:51:381] [Get-AzADALToken] - Executing Azucar with Client credentials authentication flow

**Exception calling "GetResult" with "0" argument(s): "AADSTS700016: Application with identifier 'XXXXXXX.XXXXXX' was not found in the directory 'ad3b1983-bb28-4abd-b3c8-e2cda805XXXX'.

This can happen if the application has not been installed by the administrator of the tenant or consented to by any user in the tenant.

You may have sent your authentication request to the wrong tenant.**

[silverhack]

Hi,

Is the managed application (Service principal) created and allowed to access to internal resources?