How to connect to sharepoint file when you have more than 1000 files?

[Anonymous]

I am trying to connect to a file in my sharepoint. But I have more than 1000 files on that site. So I am not able connect to a particular file because I am not able to see it.

I am assuming there is a way around this using Advance Editor where you could edit the query and pass file name or something to connect.

[v-lili6-msft]

hi  @Anonymous 

You could do some filter in edit queries, or do different sort for one column.

Regards,

Lin

[Nishantjain · Accepted solution]

Have you tried this 

https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

This is the best way to connect to a single file in sharepoint. 

Thanks

[Anonymous]

This looks like a good workaround, however, how often would the file be refreshed?

Thanks

[v-lili6-msft]

hi  @Anonymous 

You can configure up to eight daily time slots if your dataset is on shared capacity (free and pro users), or 48 time slots on Power BI Premium. 

https://docs.microsoft.com/en-us/power-bi/refresh-data#configure-scheduled-refresh

Regards,

Lin

[Tad17]

Hey @Anonymous 

Check out this article on the Power BI Tips & Tricks website: https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

If this helps please kudo.

If this solves your problem please accept it as a possible solution.

[Anonymous]

I know this is a workaround but I wanted something clean that can be used as a query. 

Anyway thanks though