locked
Capturing SQL Query RRS feed

  • Question

  • I have a model where I connect to a database, pull across 5 tables and perform various joins and transformations... Assuming it's all query folded, is it possible to capture theSQL query client sided without having to dig around SQL Server Profiler on the server end?

    The reason being is that I need to replicate a PowerBI model in SSAS Tabular but I don't want to re-create all of the ETL in SQL.

    Tuesday, October 20, 2015 4:00 PM

Answers

  • You could use a tool like Fiddler to capture the query request being sent to the server.

    Ehren

    Tuesday, October 20, 2015 5:09 PM

All replies

  • You could use a tool like Fiddler to capture the query request being sent to the server.

    Ehren

    Tuesday, October 20, 2015 5:09 PM
  • I'll give it a shot, thanks Ehren!
    Wednesday, October 21, 2015 12:32 PM