Forum Discussion
from Excel to Sharepoint
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-List-Access-to-resource-is-forbidden/td-p/51475
Best Regards
Maggie
Hi Anonymous
First make sure you can connect to a Sharepoint folder with Power BI Desktop.
You could follow this guide to check.
I make a test:
First connect to a local excel file (test 9.26.1) via "Excel" connector in Power BI Desktop, i get "Sheet1" in Power BI,
Then upload the folder Including excel files (test 9.26.1,test 9.26.2) to a Sharepoint document libray,
Next connect to the sharepoint folder as this guide in Power BI Desktop,
thus i get a "query1", in query1, i filter the imported data to get my desired file (test 9.26.2),
Open Advanced editor for query 1, copy the code, replace the code and paste it in the Advanced editor for "query1",
Cloase&&apply, the visual previously using columns from test 9.26.1 now uses columns from test 9.26.2, it works, not break.
This test need two files have the same data structure( same numbers of columns and same names of columns names).
Maggie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Unfortunately, I can't even go further than connecting the Power BI report to the Sharepoint, it stops at this point
the pop-up I crossed out a cross doesn't even appear, I'm stuck in the first step when trying to connect to SharePoint.
I tried with 2 different Microsoft accounts on 2 different SharePoint spaces but this doesn't change.
Hi Anonymous
What is the detailed error message?
Could you tell me what url you enter?
(hide the private information, replace them with ****(some words explanation, like my site name)
Make sure the contents in SharePoint is available for users to acess,
In my test, the account log in Power BI is the same for Sharepoint.
Best Regards
MaggieThe 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.