Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have been using SQL Profiler to monitor how Power BI is querying my database while I use Direct Query. It is selecting every row in the table. This is very inefficient, especially if I only want to report on the current weeks data. Does anyone know how I can use a custom query so I can add a simple WHERE clause?
Solved! Go to Solution.
@ankitpatira, thank you for pointing that out. I did not see that option. I will give this a try. Is there a way to pass parameters?
I see there is a checkbox for "Include relationship columns" and "Navigate using full hierarchy". Maybe these allow you to pass parameters somehow. They must be documented somewhere.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |