Forum Discussion
Unable to search Folder Path
I'm using PowerQuery by creating a dataflow in Fabric. When I'm trying to Get Data from a Sharepoint, I need to filter the folder path due to the number of files and folders I have. I use Folder Path, then click "See More", then type in the text to search. But it's not showing any results. The values are clearly there, I had to scroll a lot to find a sample.
Is there any reason for this behavior? I encounter this from time to time, but sometimes for other dataflows I create I have no issues.
you have too many items and/or folders. Use the Text filter option to narrow it down. or use SharePoint.Contents() for manual navigation.
3 Replies
you have too many items and/or folders. Use the Text filter option to narrow it down. or use SharePoint.Contents() for manual navigation.
Power Query is case sensitive. So if you type the search text, a mistake is easily made! I know from experience....
The data and screenshot you provide dont give enough information to make me sure this is your problem though...
Kees Stolker
A big fan of Power Query and Excel
Hi nogstai
Thank you for reaching out microsoft fabric community forum.
I wanted to check if you had the opportunity to review the information provided by lbendlin and PwerQueryKees . Please feel free to contact us if you have any further questions. If their response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you
