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
Highlighted
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
Highlighted
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

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors