Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sharepoint Not refreshing

Hi All I can access the sharepoint site (url) but when i click on get data and select either the hsarepoint folder or the ODatafeed i get an access denied error. Please advice. Thanks
Need Help
v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi Anonymous ,

Try the following method:

1. If your site is Office365, please enter the organizational credential using the third option in the below screenshot. If your site is on-premise, use Windows credentials as you mentioned. In addition, make sure that you use the latest version of Power BI Desktop.

 

2. Create a new pbix file and clear the Permission the data source of SharePoint you used before under Edit Queries>> Data source setting>>Global Permissions>> find the Sharepoint source >> Clear Permissions.

Here are some similar posts, you can refer to:

SharePoint List Access to resource is forbidden

Excel Document from Sharepoint - Access Denied

Best Regards,

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks V-joesh-msft,

I can access the site now , but not what i wanted . I am  getting list of projects and loading the data into power bi desktop , publish it to the service. When i make changes in sharepoint list like add a new name, i need to come into the desktop refresh and republish it for me to see the changes in the power bi service, the users arenot happy and there is a way to create the report directly in power bi service?

Thanks

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    Hi Anonymous ,

    You can connect to SharePoint directly in the service, please select Get Data in the lower right corner:

    Best Regards,

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