Forum Discussion
Limit Direct Query data with dynamic filter
Dear Power BI Experts,
I have connected my power BI desktop with Teradata (data source). It is huge database and there are some rules where power BI cannot read full table so, I have to limit data with some date filters.
Can we create these filters inside Power Query or Report view and dynamically change it to get filtered data from database ?
Thanks
2 Replies
Yes, here's the relevant documentation:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
Hi imranasif161
Herer are some ways you can refer to:
1.Power query:
You can use paramaters to filter the data between the paramaters, please refer to the following link:
Create a parameter query (Power Query) - Microsoft Support
2. date slicer
In report, you can create a date table and use it as a slicer to filter the related data, please refer to the following link:
Power BI: Creating a Date Table using DAX (linkedin.com)
Use a relative date slicer or filter in Power BI - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
