cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SharePoint Folder Not connecting all Files into Power Query

Hello, 

 

I am trying to combine (3) files in a folder on our Sharepoint site into a Query. When I combine and transform the data, the only file that comes through is the first data file. Each file corresponds to a monthly report pulled from our GPS system database. I have identified that all (3) montly files are identical (rows, columns, headers, etc.). 

 

I have created reports before when combining folders from SharePoint and have never had this issue before. When filtering the data it does not even give me the option of the other (2) files. They are just non-existant. 

 

Please help!

 
2 REPLIES 2
Community Support
Community Support

Hi @Anonymous 

Which connector do you use?

sharepoint folder or sharepoint list?

 

Does these data under the folders have the same format?

Please refer to the simple way to connect to files within a sharepoint folder.

 

Best Regards

Maggie

 

 

 

Super User III
Super User III

If there are more than 5,000 files in SharePoint that will happen.

If they are all in one folder, change the source line in the query from SharePoint.Files() to SharePoint.Contents(). Then you drill down to the folder they are in and you'll be able to see them, unless that folder itself has >5,000 files....

 

Once you drill down, and filter that folder, then do the Combine operation.



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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors