Unable to Analyze in Excel

[klinejordan]

I am a workspace admin so would expect to be able to use Analyze in Excel and Export To Excel with a live connection to the dataset created by this template since I have the build permission. However the only thing I'm able to do is export summarized data to CSV. Is this intentional? is it documented anywhere?

Analyze in Excel is greyed out:

When I Export To Excel with a live connection and authenticate, i see this message: