Connect PBI to Sharepoint with many files

[Syndicate_Admin]

First of all, thank you for reading my question.

I leave my doubt since I did not find anything like it (or I did not know how to look for 😀).

The specific point is that I want to connect from the PBI server a couple of files that I have in Sharepoint, but the problem is that on the site I have too much information and it does not get me to show the files that I need (in fact I get an alert that says "It is possible that the preview data has been truncated due to size limits") and I can't find a way to filter the information for be able to narrow the number of files. Inside the Sharepoint site I have the information organized into folders, but when I want to make the connection it does not let me use them, it tells me that the connection must be directly to the root of the site.
If someone had a similar problem and/or comes up with how I can fix it I'll thank you!

Thanks a lot!

[v-janeyg-msft]

@Syndicate_Admin  Any updates?

[v-janeyg-msft · Accepted solution]

Hi, @Syndicate_Admin 

You can connect to the sharepoint list. Then use the search bar above to all the files you need.

Reference: Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Docs

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards

Janey Guo

[Syndicate_Admin]

Reviewing a little more, including the sites in English, I see that in the following link (https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/) they propose the solution to a similar problem and say that they should filter the list to reduce the number of files (just what I am looking for).
The problem with that solution is that I do not display the menu to be able to apply filters (neither by double clicking, nor with left, right button, etc.