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.
Super UserA 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.