Forum Discussion
tvaishnav
Helper IV
Helper IVHow to create parameters in Power BI report builder with Power BI dataset is used as a data source?
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 paginat...
amitchandak
Super User
Super Usertvaishnav , refer if this can help
https://stackoverflow.com/questions/68820105/pass-a-parameter-to-dax-query-report-builder
tvaishnavHelper IV
Helper IVamitchandak 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.