Forum Discussion
connecting to sharepoint sub folder
Very clear and easy to implement. But, what if the power BI user does not have access to the sharepoint main URL but just to a specific subfolder? In this case I guess he would get an error when updating the power BI model since he cannot access the sharepoint in first place? Is there any workaround in this case?
I am unsure of your specific use case, feel free to explain a little more.
Assuming you work in a business environment, with a dedicated sharepoint site, and you have been given the ability to create reports with Power Bi by your IT department. Then it would be probable that your IT department would grant access to sharepoint. I would raise the query with them and ask them for access.
You can check if you have access by signing into sharepoint using your business credentials.
Thanks for the answer. Briefly, I have access to main sharepoint, but the person that will update power BI will have access only to the subfolder (we do not want to give him access to the full sharepoint).
Hence I suspect he will get an authorization problem when retrieving data from the source (which is the main sharepoint).
Hope now it is clearer...
Unsure why the end user would be updating the report in your use case.
Power BI allows admins to publish reports within apps. The apps can be set to refresh periodically so the data is up to date. These apps can then be shared with end users so they can view the report.
The end user shouldn't need to refresh the data if the above has been implemented.
If you want your certain users to be able to create reports in Power BI you will need to give them more access, including to sharepoint.
Let me know if I've misunderstood something.
Thanks. That is the best solution in my view. I have implemented it. Thanks again.