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'm working with a dataset in a data warehouse. It is a very large dataset but I suspect in most cases the users will only be querying newer data. I think a Direct Query solution will likely work, but I wondered what the best place is to put in my date filters would be. Is it better to insert these filters at the Power Query level or in Power BI? Or does it matter since the queries are only actually sent when a visualization is refreshed?
Theoretically, then, I could insert a report-level filter for dates and have that set as default but allow report viewers to change it if for some reason they want to query older data? In most cases that should keep performance within reasonable bounds, right? If that works, it seems like a nice compromise.
Solved! Go to Solution.
Doesn't really matter in Direct Query but you can use Power Query as a sort of safety net. Whatever the users filter in the UI will be added to the Power Query filters.
Doesn't really matter in Direct Query but you can use Power Query as a sort of safety net. Whatever the users filter in the UI will be added to the Power Query filters.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |