cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Download & Modify a report from Power BI server which you don't have access to its data source

Hello Everyone,

 

Kindly I need your help to answer the below questions regarding PBIRS

 

 

Connection scenarioConnection scenario

 

I have the following scenario: Usar A has access from his personal PC to "x data source", and he created a report by using the data from this "x data source". Then he uploaded this report to the PBIRS. Please notice that the PBIRS also has an access connection to the  "x data source",  and User B only has access to the PBIRS but not the "x data source".

 

  1. If User B downloaded the report (which was created by User A) on his personal PC, can he has access to the "x data source" and refresh the report only because he has access to PBIRS?
  2. Will User B be able to modify the report on his personal PC even if he doesn't have access to the data source of the report? if yes, then if he uploaded the report to the server again, will we be able to make the "pre-set refresh job" to refresh the report again?

 

Thank you so much in advance 😀

1 ACCEPTED SOLUTION

Accepted Solutions
Memorable Member
Memorable Member

Re: Download & Modify a report from Power BI server which you don't have access to its data sour

Hi @alqithmi ,

first you have to differentiate between work on a report in Power BI Desktop and work on a report in Power Query. If the user downloads the report and is not permitted to the datasource he can't work in the Power Query editor. Also you can enable this function by giving the User the right roles or folders.

So yes the User can modify the reprot but only the frontend - switch the visuals make new KPIs etc. (if the datasource is imported otherwise it wont work because the user must authenticate if its a direct query).

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

 

View solution in original post

1 REPLY 1
Memorable Member
Memorable Member

Re: Download & Modify a report from Power BI server which you don't have access to its data sour

Hi @alqithmi ,

first you have to differentiate between work on a report in Power BI Desktop and work on a report in Power Query. If the user downloads the report and is not permitted to the datasource he can't work in the Power Query editor. Also you can enable this function by giving the User the right roles or folders.

So yes the User can modify the reprot but only the frontend - switch the visuals make new KPIs etc. (if the datasource is imported otherwise it wont work because the user must authenticate if its a direct query).

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.