Forum Discussion

CJJulius's avatar
CJJulius
New Member
4 years ago

Securing PowerBI Data Sources for Sharepoint Access

Hey there,   We have a few Analysts that use Sharepoint as a source for a report they are building. They'd like to set this up to refresh on a regular basis. We'd rather not have the user embed the...
Data Protection
Need Help
v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, CJJulius 

 

Please check the following document, hope it can help you.

https://docs.microsoft.com/power-bi/connect-data/refresh-desktop-file-onedrive 

https://docs.microsoft.com/power-bi/connect-data/refresh-scheduled-refresh 

https://community.powerbi.com/t5/Service/Set-access-data-from-sharepoint-as-source/m-p/1904545 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

CJJulius's avatar
CJJulius
New Member
4 years ago

This is kind of generic how to use sharepoint as a source and set up a data refresh. This works fine for us and is not a problem. The problem we're running into is giving all the report developers access to the workbook and thus data sources allowing them to get into places in Sharepoint they may not be normally able to access. So far it seems that this is not possible in PowerBI which is a shame but I guess we'll have to work something else out.