Forum Discussion
CSV files from sharepoint - Permission
The only interaction is the refresh and it is working with your account. The other users check an import of the data in power bi. It doesn't matter if it is from sharepoint, onedrive or database. The final users are checking a Power Bi data imported.
They won't need permission in sharepoint.
Regards,
Thanks for your reply Ibarrau. That means Power BI Service is authenticating the connection as me to refresh the data , what happens when the end users access the report from Workspace and App, it still connects as me? It should be connecting as end user right ?
Super UserThe only interaction is the refresh and it is working with your account. The other users check an import of the data in power bi. It doesn't matter if it is from sharepoint, onedrive or database. The final users are checking a Power Bi data imported.
They won't need permission in sharepoint.
Regards,
Thanks, what you say makes sense for imported mode. What happens if I leave the company and my AD account is closed? What is the best practice in this area ? Do we use separate account for the purpose of publish and refresh and not chained to an individual user?
Regards,
- ibarrau
The best practise here is to have a service account for conection that is administrated by the IT team of the company. You can ask IT team to create an account like pbi_service_admin@company. In that case you connect Power Bi with that account and it should work always because that account won't leave the company haha.
Regards,