Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

OneDrive for business folder connector

Hi all  Im trying to set up data source based on onedrive folder - ive created flow with power automate to download all the reports when the mail with attahment arrives - it works well, so i have no...
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    3 years ago

     

    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

     

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 

As you're obviously aware, OneDrive for Business is built on the SharePoint platform. Microsoft are quite open about the fact that they neither encourage nor support SharePoint being used as a data warehouse and, indeed, openly throttle SharePoint requests that behave in this way in order to maintain the stability of the rest of the platform for regular users. To be honest, I have to agree with them on this.

 

That being said, as far as I'm aware, there's no limit to the number of files you can import, as long as your published PBIX size is < 1GB. When you reference the 1,000 files limit, are you confusing this with the 1,000 row preview data?

 

Pete