Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I know basic DAX. Good enough to write basic measures. But I cannot really write full DAX queries like SQL query.
I have a Power BI dataset available in Power BI service. I need to create paginated report using that dataset. This requires DAX query. Per MS documentaion, I can use performance analyzer to grab DAX query and use that to create dataset. However, those won't include parameters. Is there a easy way to add parameters to DAX query? Or it is just better to use Query designer?
Thanks!
@tvaishnav , refer if this can help
https://stackoverflow.com/questions/68820105/pass-a-parameter-to-dax-query-report-builder
@amitchandak Thank you for taking the time to respond.
That link did help somewhat and eventually I found this link to Chris's blog: https://blog.crossjoin.co.uk/2019/11/03/power-bi-report-builder-and-rscustomdaxfilter/
Looks like using DAX is way more complicated that I thought. If I have to choose between DAX and SQL for these reports, what should be a default choice?
I was inclining to DAX because I can resue the existng model. But that model gets all its data using SQL anyway.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
71 | |
63 | |
57 | |
49 | |
46 |