Getting Started with Paginated Reports 101: Part 4 (2023) - Query Filters v. Query Parameters
2.7 هزار بار بازدید -
پارسال
-
Let’s dig into filters and
Let’s dig into filters and parameters in paginated reports to better understand how and when to use them both.
This video covers the mechanics of how both parameters and filters work at report run time and what that pesky RSCUSTOMDAXFILTER is up to when you generate a query with parameters that uses a Power BI dataset as your report’s data source. Finally, we’ll demystify whether you should use a dataset filter rather than a query filter when designing your report.
Accompanying Blog Post: https://caf2code.com/paginated-report...
Don’t just watch; follow along! All files and additional instructions are available for download on Lenore’s GitHub to help you practice: https://github.com/lenoreflower/Pagin...
00:00 - Query Filters v. Query Parameters.
00:50 - Adding static and dynamic query filters.
03:20 - What happens when a Query Filter is applied.
04:10 - What happens when you add a Query Parameter.
05:49 - Demo: Adding Query Parameters
07:41 - How a report parameter works as run-time.
09:35 - What the RSCUSTOMDAXFILTER contributes to your query.
10:45 - Making sense of Dataset Filters.
12:01 - Dataset filters that mimic query parameters.
14:03 - Next Steps
This video covers the mechanics of how both parameters and filters work at report run time and what that pesky RSCUSTOMDAXFILTER is up to when you generate a query with parameters that uses a Power BI dataset as your report’s data source. Finally, we’ll demystify whether you should use a dataset filter rather than a query filter when designing your report.
Accompanying Blog Post: https://caf2code.com/paginated-report...
Don’t just watch; follow along! All files and additional instructions are available for download on Lenore’s GitHub to help you practice: https://github.com/lenoreflower/Pagin...
00:00 - Query Filters v. Query Parameters.
00:50 - Adding static and dynamic query filters.
03:20 - What happens when a Query Filter is applied.
04:10 - What happens when you add a Query Parameter.
05:49 - Demo: Adding Query Parameters
07:41 - How a report parameter works as run-time.
09:35 - What the RSCUSTOMDAXFILTER contributes to your query.
10:45 - Making sense of Dataset Filters.
12:01 - Dataset filters that mimic query parameters.
14:03 - Next Steps
پارسال
در تاریخ 1402/02/26 منتشر شده
است.
2,784
بـار بازدید شده