User defined parameter templates

[rnola16]

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 parameters. I'm able to run them and schedule them in PBI service.

But when other users open the semantic model they cannot edit the parameters and see this message under 'semantics'. I understand this feautre is only permissible for creators but How can I make templates with parameters available to end users who can put values of their choice and execute them from workspace. These parameter values run into billions of records. Thanks.

[Anonymous]

Hi @rnola16,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.

[Anonymous]

Hi @rnola16,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @rnola16,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @rnola16,

Thank you for reaching out in Microsoft Community Forum.

Thank you @rajulshah , @Deku  for the helpful response.

Please follow below steps to acheive this;

1.Power BI parameters aren't editable by end users in the service—use slicers instead for user input.

2.Replace parameters with slicers (e.g., for Date, ID, Age) so users can interactively select values in the report.

3.Use performance tuning (e.g., query reduction) and apply Row-Level Security if needed for user-level data filtering.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[rajulshah]

Hello @rnola16 ,

I thinnk following 2 links can be useful to you.

Proposed solution - Create an appworkspace for your organization or your team and then publish it. And the team needs to install the published app and then can use the report on Power BI service.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

https://learn.microsoft.com/en-us/power-bi/connect-data/service-template-apps-tips#parameters 

Please let me know if this doesn't help.

[rnola16]

How can users run a report from Apps with their choice of parameters ?

[Deku]

Dynamic M Query Parameters

[rnola16]

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.

[Deku]

In the example you can see you can define a default value, which can then be overwritten by the user in the report