Forum Discussion
CSV files from sharepoint - Permission
hi,
I have built a Power BI report based on bunch of csv files using import method. The location of these files are in sharepoint online. If I publish this report in Power BI.com do we need to provision sharepoint folder level permission for those end users to access the data?
When I publish the report to Power Bi Service , the pbix file goes with the embedded data right? If the data is embedded and user is permissioned to view the report in Workspace , do they still need permission to sharepoint data folder ?
regards
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,
5 Replies
- ibarrauSuper User
Hello. It is not neccessary that the final users using the report in power bi service have permission to the folder in sharepoint. The account that connects to sharepoint data in Power Bi Desktop is the only one that need the permission to the folder. Then you have to re-login to sharepoint in Power Bi Service with that account in order to refresh data. That is the bridge between sharepoint and power bi, the one account you configure.
Hope this helps
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
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 ?
- ibarrauSuper User
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,