Forum Discussion
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. Bu...
How are you setting the filter? If you are using the filters collection on the paginated dataset object then the behaviour is expected. If you want to push the filter down to the source you need to map your report parameter to a query parameter and use the parameter in your DAX query.