Forum Discussion
Unable to access to SharePoint Folder with Files
- 6 years ago
Well, you can answer that better than me I guess 😛 I do get the account option screen when I use your site, obviously I cannot go further but here you should login with your Office 365 account:
Did you get this screen? And what account did you use? (And just to be totally sure: this is not a on premise SharePoint instance right?)
That doesn't seem right, your M code refers to SharePoint.Tables but when I try it it refers to SharePoint.Files:
Are you using an up to date PowerBI Desktop version? And did you select SharePoint Folder (not list!)?
EDIT: when i try to connect to a Sharepoint Online List, i get a similar view as you. Seems you need to connect to a SharePoint folder.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Hi JarroVGIT
I cannot connect to a sharePoint.Files
I tried SharePoint.Tables because sharePoint.Files doesn't work.
I have an error when trying SharePoint.Files
My version of Power BI is November 2019.
"Version: 2.75.5649.961 64-bit (novembre 2019)"
- JarroVGIT6 years ago
Resident Rockstar
Your site URL seems off. Please try replacing it with the URL i gave in the first reply
e.g. https://totalworkplace.sharepoint.com/sites/lub-metiers/
(note the / at the end!) Perhaps it is best to start a new query, and select Sharepoint Folder with the above URL. If that doesn't work, please post screenshots of what you are seeing.
- augustindelaf6 years ago
Impactful Individual
Hi,
I did exactly like you said.
> New Query>SharePoint Folder (a)SharePoint Folder
Then there is an error (b)
Details: "Access to the resource is forbidden."
- augustindelaf6 years ago
Impactful Individual
https://community.powerbi.com/t5/Desktop/SharePoint-List-Access-to-resource-is-forbidden/td-p/51475
Maybe that JarroVGIT ?