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
v-juanli-msft's avatar
v-juanli-msft
Community 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 !