Forum Discussion
User defined parameter templates
Hi, We have Business Objects report where users ( 200+ ) would schedule them with their choice of parameters ( date/ID/age/etc). I created same report in PBI using direct query with same SQL and...
To create dynamic M query parameters you first need to create a table and bind that to the column. I cannot create a table which brings in billion records on the report and filter from there. Also, the time period runs for 20 years, cannot list 20 yr days in the report.
In the example you can see you can define a default value, which can then be overwritten by the user in the report
