Power bi data filter

Question

Hi&nbsp;I have a report with million of data to be fetched into a table.there is 1 slicer and multiple text filters.The issue which we are facing is that the moment a value is selected in slicer it starts running and fetching data into the table which it takes a lot of time to do. So is it possible to find a way where-1) till the time 1 slicer and text filter applied it should not fetch the data&nbsp;2) slicer can internally filter the data but when text filter is applied then it visually displays it ? (It is not working via edit interactions)

lbendlin · Answer

There are tenant level limits (like the 1 million you mentioned) and there are physiological limits.&nbsp; No report user will ever scroll past the first 500 values in a slicer or table.&nbsp;
&nbsp;
Use the filter pane instead, and pre-filter by other columns.

learner82 · Answer

I tried working with top n but it is still taking 30 seconds to just fetch it. I am assuming it internally fetches the million of rows first and then shows top 100&nbsp;

lbendlin · Answer

pre-filter by other columns, ideally with much lower cardinality.

learner82 · Answer

Sorry, I am new to this . If I am assuming it correctly, we can apply prefilter based on dates or something. But if we use search filter later which crosses that date them it won't work right?&nbsp;Also is it possible that the table only shows result if we apply textfilter + slicer?

lbendlin · Answer

define "results".&nbsp; By default Power BI will page data in as needed (the aforementioned 500 rows) or run aggregation queries to only show distinct values.
&nbsp;
What are you trying to accomplish with your report?

Forum Discussion

Power bi data filter

6 Replies

Related content

Filtering Data

Data transform using power query

Filter data using slicer

Bookmarks Filter Data

Dynamically export filtered data to CSV via Power Automate