parameter change in powerbi service

[Jaweed]

Our powerbi report can take a paramater date and query the SQL server database using some complex queries. It is working fine, I created the report, and as such I am the owner. I can change the parameter easily on either PBI Desktop or PBi Service. The report has been published. However the users in powerbi service do not see the dataset and therefore do not have the option to change the parameter of the report. It is an ageing report and we need the report to be generated as per a given date which the users as a parameter.

Can anybody help me? Has it to do with access rights? I need to allow staff of the concerned Dept to generate the PBI report as per the date they need, by allowing change of parameter. Many thanks fpr your help.

[v-juanli-msft]

Hi @Jaweed 

If users have no access to the dataset, it is impossible to edit parameter in Power BI Service.

You could publish reports to a app workspace, then publish an app to the users.

the users can have an app with reports, datasets and dashboards.

You may add the users as users of the gateway where you configure schedule refresh for the dataset.

One thing to take note of, is that this currently only works on Imported data sources and not DirectQuery or LiveConnection.

Or for users who only consume reports, they could pass parameters in URL to filter report.

https://carldesouza.com/passing-parameters-in-url-to-filter-a-power-bi-report/

https://docs.microsoft.com/en-us/power-bi/service-url-filters

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jaweed]

@Maggie

thank you very much.

Unless I am doing it wrong, I am not having the desired output. I am using imported data source. I have created a workspace app and share with users. I would like the users to be able to edit the parameters and refresh the data set. To do this, I had to let one user take ownership of the dataset, which I do not want, I am no longer the owner and could not proceed further. I want to share the published report in powerbi service to 5 users and gather should be able to run the report based on the parameter they input. When they input the parameter, powerbi goes and fetch the data from the database. It is not a filtering within powerbi itself. Thanks to advise me. I am locked since weeks with this issue.

[v-juanli-msft]

Hi @Jaweed 

1.

don't let the users to take owner of your dataset.

To make users to have permission to edit parameter:

If you use classic (old) app workspace, just set "give edit permission for members" and add users as members,

If you use New app workspace, just give build permission to users.

To make users to be able to refresh dataset,

Add users in the user list under the gateway which you refresh the dataset with.

2. If you don't want users to change the data imported in a power bi dataset, don't do as 1 suggested.

You just follow the article below

https://carldesouza.com/passing-parameters-in-url-to-filter-a-power-bi-report/

https://docs.microsoft.com/en-us/power-bi/service-url-filters

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gilbertendaya]

Hi @v-juanli-msft A question here. I added the build permission with a user that has pro license but the Parameter section is still greyed out. Please advise. Thank you.