Forum Discussion
OneDrive for business folder connector
Ok, so are you talking about this?:
If so, then you can explicitly define your filter conditions rather than selecting individual items from this list. This allows you to specify if a file path Starts With, Contains, Ends With (etc.) certain text and applies the filter to the entire dataset, ignoring any preview limits:
Pete
Hi Pete,
Yes i mean 1k files limit when i try to apply the filter in power query to filter out the folder i need to combine files from. The tutorial i mentioned was including the way of combining files by importing main sharepoint folder and then filtering out the path to desired folder and after that some manual edits to merge files from one path.
Im fairly new to BI and im just trying to figure out things, If this way of storing data isnt really supported i will need to find another way. I think to set up a server or use power automate flow to combine the folder files into one (which seems to be more convenient way).
Thank you for your input.
Ok, so are you talking about this?:
If so, then you can explicitly define your filter conditions rather than selecting individual items from this list. This allows you to specify if a file path Starts With, Contains, Ends With (etc.) certain text and applies the filter to the entire dataset, ignoring any preview limits:
Pete
Thank you Pete,
Having this in mind, building variety of dashboards from multiple files i think merging the files into one "db" on onedrive will allow me to automate it quicker.
I still believe connector for onedrive should be available as at least as some kind of addon with warning about stability.
Anyway, appriciate your help 👍