Forum Discussion

Sudharsanan's avatar
Sudharsanan
Helper III
4 years ago

Loading selected data in power query/BI

Hello Folks,   I am trying to load  few rows from the large data using power Query. for example the file have 1000 rows and i need to load only the rows with certain keyword from a clolum. So is it...
Need Help
Sudharsanan's avatar
Sudharsanan
Helper III
4 years ago

Thank you BITomS for your promt response

 

Actuall my source is in actual desktop where other application drops the file with month Name for everymonth. so i wanted my query to be updated based on the month dynamically. for example, if the file is placed for Aug 2022, my file should get refreshed without any manual changes on the source.

 

hope this gives better understanding:)

BITomS's avatar
BITomS
Solution Supplier
4 years ago

Sudharsanan - yes, this sounds like a completely different issue to the original post!

 

For the problem in your response, you can use the connection from 'Get Data' > 'More' > 'File' > 'Folder' and enter the folder path. You must ensure the folder location contains only the files you need and that they have aligned formatting. This article may help: https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4

 

Edit: I just re-read your response and it sounds like you are just focused on a single file being stored in the same location - in this case, you can filter the table based on the file created date using the Date/Time filter: Is Latest.