Direct Query with Predicate?

Question

I have been using SQL Profiler to monitor how Power BI is querying my database while I use Direct Query.&nbsp; It is selecting every row in the table.&nbsp; This is very inefficient, especially if I only want to report on the current weeks data.&nbsp; Does anyone know how I can use a custom query so I can add a simple WHERE clause?

ankitpatira · Accepted Answer

jsBrizius&nbsp;in power bi desktop, for sql connector you can define custom sql queries.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Direct Query with Predicate?

2 Replies

Related content

merging direct query queries

RLS over Direct Query

Direct Query issue with Snowflake

MySQL Connector - Direct Query

History Data in Direct Query