Excel Pivot Table from SQL Server cannot show non-aggregate

Hi guys.

I believe many would have tried to do the same - I want to make excel show the result of a few sql server tables, joined based on the specified relationship. Better still if there's a way to make excel display the results of a specific sql query. I need to save this excel file and whenever I refresh data connection it should update from sql server.

I gave pivot tables a try, adding connection and inserting pivot table. However pivot tables seem to be meant for other purposes and it sums up values which I want to display as text. I tried dragging the fields I want into Rows, and report layout > show in tabular form, but this won't work if i'm dragging a field from another table.

I think the ideal situation is that I can make excel display the results of a particular sql server query. Otherwise, some guidance with pivot tables to achieve the same would be greatly appreciated

Thanks!!

Thanks. I'm exploring the New Query function now.