Excel Report not being generated about ari HOT 3 CLOSED

Check the version of the az resource graph that's installed along with az cli

az --version

(This is my output)
azure-cli 2.27.1
core 2.27.1
telemetry 1.0.6

Extensions:
resource-graph 2.1.0

If it's not at 2.1.0 then remove that with

az extension remove --name -resource-graph

Now, install the latest

az extension add --name resource-graph

Try to run the script again

from ari.

I pulled down the latest version of this script and I can confirm the same errors -

 |                  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 | The property 'HorizontalAlignment' cannot be found on this object. Verify that the property exists and can be set.

Line |
128 | … $Range.Style.Numberformat.Format = (Expand-NumberFormat $ …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The property 'Format' cannot be found on this object. Verify that the property exists and can be set.

WARNING: Failed autosizing columns of worksheet 'Subscriptions': You cannot call a method on a null-valued expression.
WARNING: Failed adding PivotTable 'P1': Index operation failed; the array index evaluated to null.
WARNING: Failed adding chart for pivotable 'P1': Cannot bind argument to parameter 'PivotTable' because it is null.

from ari.

I had checked the versions and it seemed fine, I have just updated to use Powershell 7, and now it´s working...

from ari.