Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

from Excel to Sharepoint

Good morning, everyone,   I have a problem that I can't find a solution to on the forum, I hope you can help me. I created a dataset in Excel to report on PBI Desktop. In order to allow users to ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

 

The URL I use is : https://***group.sharepoint.com/sites/gr******board/

 

and here is the error message that appear after few seconds, it says :

 

Connexion impossible

we encountered an error when trying to connect

Details : Access to the resource is prohibited

and  it's the same log in power bi desktop as in SharePoint.

 

 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Which connector do you choose?

In my test, i choose the "sharepoint folder",

if you are connecting to a sharepoint list, please choose "sharepoint online list" connector.

 

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.

then re-connect to " https://***group.sharepoint.com/sites" with Power BI Desktop to see if it works.

Also test with the lastest version.

 

Some similar threads you could refer to:

https://community.powerbi.com/t5/Desktop/Sharepoint-Folder-to-Power-Bi-Access-to-the-resource-is/td-p/439763

https://community.powerbi.com/t5/Desktop/SharePoint-List-Access-to-resource-is-forbidden/td-p/51475

 

Best Regards
Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    As you said, i deleted all permission, downloaded the last version (Sept.) and i have now this screen poping where I put the URL.

     

    I'll try to connect with the 3 option (and deleting permission between each test) to see which one is the good one.

     

    Thank for your previous answers, I'll edit this message when i'm done whith these tests.

     

    EDIT : It works, deleting permission was the solution. I mark it as solved.

     

    Thank you very much !