cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ptmuldoon
Frequent Visitor

Sharepoint Folder; Missing Folders/Files

I'm still very new with Power BI and Power Query in general, and having some issues in trying to access files via SharePoint Online (we use office 365)

 

I can enter the URL for our sharepoint site and sign on with my Org Credentials.  But after I can't seem to filter or find most of the files on our SharePoint site that I do have rights and permissions too.

 

When i access our sharepoint site via web browser, I can navigate between folders and see and open pretty much any file, etc.   But in Power Query, I do not see pretty much any of those files.  I'm not sure if I need to go back our our company's IT department yet to check permissions or not.

 

I also have a mapped drive to our SharePoint files, and can also navigate and see them that way.  And that did work by loading a file in power query that way.  But I can't rely on the mapped drives alway's being there (drive letters change).

 

Is there something I'm possibly missing in trying to locate certain folders/files via Sharepoint Folder?

 

Thanks,

PT

3 ACCEPTED SOLUTIONS
lbendlin
Super User III
Super User III

Which connector did you use, Sharepoint Folder or Sharepoint List ?

By the way there is another connector that you can try - SharePoint.Contents - PowerQuery M | Microsoft Docs  - it gives raw access to all content.

Also set the API level 14 if you still have issues (15 is sometimes iffy)

View solution in original post

edhans
Super User III
Super User III

@ptmuldoon The default SharePoint.Files connection only lists the first 5,000 files, so it might not find everything. In the Source line for the SharePoint connection change SharePoint.Files to SharePoint.Contents (it is case sensitive) in the formula bar (make sure that is visible in the View tab of Power Query - check the "Formula Bar" button) then drill down the folder structure. The first place you probably need to go is to Share Documents, then you will start to see files and folders that make sense.

 

I generally prefer SharePoint.Contents as it is faster, but it does have one drawback. When you are combining files, you can only combine files in one folder vs SharePoint.Files which will combine whatever files you filter down to. But SharePoint.Contents doesn't have the file listing limitation .Files does.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

ptmuldoon
Frequent Visitor

Thanks guy.  Both of you pointed me in the right direction and with SharePoint.Contents was able to drill down and locate the file(s).

 

I'm sure I'll be back with some more questions though 🙂

View solution in original post

3 REPLIES 3
edhans
Super User III
Super User III

@ptmuldoon The default SharePoint.Files connection only lists the first 5,000 files, so it might not find everything. In the Source line for the SharePoint connection change SharePoint.Files to SharePoint.Contents (it is case sensitive) in the formula bar (make sure that is visible in the View tab of Power Query - check the "Formula Bar" button) then drill down the folder structure. The first place you probably need to go is to Share Documents, then you will start to see files and folders that make sense.

 

I generally prefer SharePoint.Contents as it is faster, but it does have one drawback. When you are combining files, you can only combine files in one folder vs SharePoint.Files which will combine whatever files you filter down to. But SharePoint.Contents doesn't have the file listing limitation .Files does.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

ptmuldoon
Frequent Visitor

Thanks guy.  Both of you pointed me in the right direction and with SharePoint.Contents was able to drill down and locate the file(s).

 

I'm sure I'll be back with some more questions though 🙂

View solution in original post

lbendlin
Super User III
Super User III

Which connector did you use, Sharepoint Folder or Sharepoint List ?

By the way there is another connector that you can try - SharePoint.Contents - PowerQuery M | Microsoft Docs  - it gives raw access to all content.

Also set the API level 14 if you still have issues (15 is sometimes iffy)

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors