cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

Hi @manalla,

 

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

 

q9.PNG

 

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. 

 

q10.PNG

 

Best Regards,
Qiuyun Yu

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

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

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

Hi @manalla,

 

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

 

q9.PNG

 

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. 

 

q10.PNG

 

Best Regards,
Qiuyun Yu

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

View solution in original post

Highlighted
Regular Visitor

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

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

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors