Limit Direct Query data with dynamic filter

[imranasif161]

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

[v-xinruzhu-msft]

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.

[otravers]

Yes, here's the relevant documentation:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters