[URGENT] 1 Million Limit in Direct Query

[Anonymous]

When using direct query mode , it is failing with 1 million limit ,Can we use dynamic filtering of data so that based on the filter selected only if it will refresh the backend table reffered. Actual back-end table will contain the entire record and based on the power filter ,power BI will fetch only the required data which is lessthan 1 Million. Other alternatives are also welcome

[kentyler]

You can use parameters to affect the rows returned by Direct Query. Take a look at this blog post. https://blog.gbrueckl.at/2019/03/using-power-bi-desktop-direct-query-with-parameters/

[Anonymous]

Can we put a dynamic filter in each of the queries in powerbi like selected value in the filter.But the challenge here is the filter has multiple selection option.