Skip to main content
Microsoft Idea

Power BI

Completed

View DirectQuery statements issued against data source

Vote (6) Share
's profile image

on 29 Apr 2016 23:04:25

When working with SQL server, seeing actual SQL statements can help with data preparation, e.g. user can choose to materialize the data as new table to improve performance of further transformation/visualization steps.

Administrator on 12 Apr 2017 01:41:14

This is available in the right-click menu within the Steps pane. Select an specific step and you'll find "View Native Query" as a context menu option. This will give you the underlying query sent to the source. Note that in cases where the query no longer "folds" to the underlying source (i.e. because you're using non-supported transformations in that source), this option will be disabled.