Forum Discussion
Impactful IndividualUnable to access to SharePoint Folder with Files
Hi,
I am currently struggling to access to excel files in a sharepoint environment.
The context : multiple excel (.xlsx) files of the same type in a SharePoint folder, I try to access to their content (into one single table) but not possible.
Can anyone help me please ?
I already did that 3 years ago, successfully with a "SharePoint.Files" method, the context was exactly THE SAME.
But now it does'nt work ! So frustrating.
I even tried SharePoint Folder, SharePoint Online List and SharePoint List. None of them works.
I tried the root URL, the specific URL, the mid specific, the mid root ....
I even tried with Dataflow ...no changes. I can provide SCREENSHOTS
Can anyone help me please ?
--
My final URL :
COMPANYXXXXworkplace.sharepoint.com/sites/lub-metiers/lubmarine/tma/Documents%20partages/Forms/AllItems.aspx?csf=1&%3Be=kW9yIL&RootFolder=%2Fsites%2Flub-metiers%2Flubmarine%2Ftma%2FDocuments%20partages%2FDRAIN%20OIL%20REPORTS&FolderCTID=0x01200097EB595E2919AF45910AAE8B12F6B151
--
The URLs I tried :
COMPANYXXXXworkplace.sharepoint.com/
COMPANYXXXXworkplace.sharepoint.com/sites
COMPANYXXXXworkplace.sharepoint.com/sites/lub-metiers
--
The method that worked on another project with exact same context 3 years ago :
let
Source = SharePoint.Files("https://COMPANYZZZZZgroup.sharepoint.com/T2P"),
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?)
9 Replies
- JarroVGIT
Resident Rockstar
Are you logged into Power BI Desktop with an account that has access to the Sharepoint environment?
https://COMPANYXXXXworkplace.sharepoint.com/sites/lub-metiers/ should be working with the 'Sharepoint Folder' connector, it works for me anyway. Can you provide screenshots?
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 🙂
- augustindelaf
hi JarroVGIT
Thanks for your kind help.
>> Yes, my pbi desktop has access to the sharePoint environment (I have another table in that file that successfully gets data from a list into that same SharePoint, so i'm 100% sure it's not an issue)
Actually, I can access to the root through a "SharePoint.Tables" request (screenshot):
I can access to the root of the sharePoint. Where should I go now ? When I go to "Documents", I can see my files but I am unable to access to their content.
Then I have multiple options and I choose "Documents" because it enables me to see the names of my files.
But, there is no way to deep dive into their content !
There should be a column named "Content", to be expanded, no ?
Thx
- JarroVGIT
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 🙂
