Using SQL data as the data source for an Excel pivot table when the SQL uses an SQL Table Valued function

Question

Using Microsoft Query I'm trying to setup a sql data source for an Excel pivot table, specifically when the sql contains a table valued function. The sql shown in the picture below is how it successfully runs in SSMS.

I've used sql as a data source many times for an Excel pivot table, but never when the sql is using a table valued function as a table source.

I'm getting the following error when I try to add it as the data source for my excel connection.

Answer 1

When I returned to Excel from MS query I was able to update the sql there. It then worked.