Forum Discussion
Updating parameter in a published report
devnull wrote:
How can one make sure the uploaded report gets the changes as well?
So if you want the same parameter value in your pbix file and on the server then just set the parameter in PBI Desktop before you upload it.
devnull wrote:
This couldn't be the intended feature, can it?
I'm pretty sure this is by design. One of the common use cases for an admin to override a parameter on the server it's because the user only has access to a dev/test server or database. So they develop the report against that non-prod data, then they upload to the Report Server and the scheduled refresh pulls from the production database or server.
When you are in this scenario and the user clicks on "Edit in Power BI Desktop" the user would need to use the non-prod parameter to make any changes to the report. If the parameter values from the server were merged in then they would get access denied errors when attempting to change anything in the queries.
It can be confusing at first to see a different data when you click on Edit compared to what you see on the server, but I believe the scenario above is what they were targeting.
You are right. After a scheduled refresh, the report indeed points to the proper db, BUT:
What will be extremely confusing for the users: if they try to edit this "updated" report (with "Edit in Power BI Desktop" button), then save, and publish their changes back to the server, they publish back the old database name again.
Now i have two entities on the server:
1. one is the backsground, updated report, which is observable through the web ui
2. other is the old version opening up through the "edit in power bi dekstop" button
This couldn't be the intended feature, can it?
How can one make sure the uploaded report gets the changes as well?
Do it right when uploading?
devnull wrote:
How can one make sure the uploaded report gets the changes as well?
So if you want the same parameter value in your pbix file and on the server then just set the parameter in PBI Desktop before you upload it.
devnull wrote:
This couldn't be the intended feature, can it?
I'm pretty sure this is by design. One of the common use cases for an admin to override a parameter on the server it's because the user only has access to a dev/test server or database. So they develop the report against that non-prod data, then they upload to the Report Server and the scheduled refresh pulls from the production database or server.
When you are in this scenario and the user clicks on "Edit in Power BI Desktop" the user would need to use the non-prod parameter to make any changes to the report. If the parameter values from the server were merged in then they would get access denied errors when attempting to change anything in the queries.
It can be confusing at first to see a different data when you click on Edit compared to what you see on the server, but I believe the scenario above is what they were targeting.
Thank you d_gosbell! Yes it is confusing, but it seems it is what it is.