Appending the first x number of files from a OneDrive folder

[PowerWhy]

Hello,

I understand it's possible to append all the files together from a OneDrive folder, but please could you tell me if it's possible to append only, say, the first 30 files (by modified date or by alphabetical order).

Thank you!

PW

[Anonymous · Accepted solution]

Hi @PowerWhy ,

Please refer to this document to connect to onedrive using the sharepoint folder connector.

https://<unique_tenant_name>.sharepoint.com/personal/<user_identifier>

SharePoint and OneDrive for Business files import - OneDrive for Business experience

All files are shown here, you need to find the [Folder Path] field and filter the folder path.

Next you can sort the files and keep the first thirty.

Finally click on this button to append the query to all files.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Ashish_Mathur]

Hi,

I am not sure but try this.  Once the tables of that folder load in the Query Editor, click the Keep Rows button in the ribbon and type 30 there.