Forum Discussion
Sharepoint folder does not show up in Power BI's Power Query
A couple of things to consider.
First, if you are using a single Excel file from SharePoint you do not need the SharePoint Folder connector. You can use Excel.Workbook(Web.Contents("fileURL")). This is way quicker from a performance perspective.
Second, by default Power Query only lists the first 1000 rows of a given query. If the SharePoint folder you are querying has more than 1000 items then it is possible your file is there, just not being displayed. You can change the 1000 rows limit with the button on the lower left corner of the query screen.
There is no way you should have to wait 3-5 days for your files to show up.Hope this helps.
Thank you so much for your response, the preview limit of 1000 rows was indeed the issue.
However, I didn't find the button in the lower left corner of the query screen that you mentioned... might just be me not looking in the right place though. Anyway, I solved the 1000 rows limit issue by replacing source = Sharepoint.Files for source = Sharepoint.Contents, then navigating all the way to the folder I needed (disclaimer: I need the Sharepoint Folder connector because more files will eventually be added to that folder and I need to take those into account too).
Thanks again for the reply!
Super UserI didn't have PBI open when I wrote my initial response. Here is the "button" in the Power Query Editor.
Glad you were able to solve your issue.