CODEWITHSUNDEEP
sql-serverexcelexport-to-exceltable-valued-parameters
TeleJim
TeleJim

Reputation: 317

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

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.

Error when using an SQL table value function in Excel

Upvotes: -1

Views: 421

Answers (1)

TeleJim
TeleJim

Reputation: 317

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

Upvotes: 0

Related Questions