Direct Query in Report builder
We have a paginated report that pulls that using direct query. In the dataset, I passed the hard coded values to filter the data. It's working fine at execute the DAX to pull the filtered dataset. But once I published the report and I see that the reports pulls the full set of data instead of pulling the subset of data. Any idea if direct query will pull everything and then will put the filters on the whole dataset instead of filter applied in the dax itself.