Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
Yes, here's the relevant documentation:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters