How will users edit the report in Power BI report server - Access and Client related?

[manalla]

Hi,

Once developer publishes the report to report server, there are few Power Users who will need to edit the report (They will not have admin rights on their machines for sure).

1. When user click on edit report, will PBI desktop open with a client OR pre-installation of PBI Desktop for report server is requried on Power User machines?

2. Once first step is complete, how will Power user connect to database to refresh? I mean what options do we have?

a. They will not have access to DB?

b. Service account cred's can be saved and same can be used when power user make changes to report?

c. Any other possible options when they dont have access to DB and we cant share service account password to power users?

Thanks

[v-qiuyu-msft · Accepted solution]

Hi @manalla,

1. If the client already have installed the desktop, it will prompt you open the report in desktop. 

2. When the client open the report in the desktop, to make sure the data can be refreshed successfully, the user needs to go to Data source Settings to verify valid crendetial. 

Best Regards,
Qiuyun Yu

[shrutigupta]

Thanks for the inputs. Please let us know if it is possible to edit the report online using reporting services i.e., without using Power BI Desktop in Power BI Report Server 2017 Nov version. we have such an option for power BI Cloud and it would be very useful if we have it for Power BI Report Server. Power Bi Service reference: https://docs.microsoft.com/en-us/power-bi/service-reading-view-and-editing-view