Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Can someone share some insight?
Solved! Go to Solution.
I've done more than 5,000, but I am not sure where the limit is, and it is not Power BI, it is what SP will return.
I would advise using the SharePoint.Contents connector instead of SharePoint.Files. Just create the connection as normal, then when you are looking at the file list, change the formula to use the SharePoint.Contents connector. it will now let you drill through to folders. As long as no folder has more than 5K files in it, you'll have no problem.
The downside is, you can only see one folder at a time, so if files are spread across folders, it is less ideal.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI've done more than 5,000, but I am not sure where the limit is, and it is not Power BI, it is what SP will return.
I would advise using the SharePoint.Contents connector instead of SharePoint.Files. Just create the connection as normal, then when you are looking at the file list, change the formula to use the SharePoint.Contents connector. it will now let you drill through to folders. As long as no folder has more than 5K files in it, you'll have no problem.
The downside is, you can only see one folder at a time, so if files are spread across folders, it is less ideal.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
42 | |
25 | |
22 | |
20 | |
17 |
User | Count |
---|---|
54 | |
43 | |
24 | |
21 | |
20 |