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...
Hi Navsharma ,
If your data source is PBI semantic model, please filter data in Powr Query then load into Power BI Desktop, then using this semantic model to create paginated report.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.