I got a query that connects to the “newest” *.xlsx file in a folder, that is automatically created every night. Its easy to filter out the latest file due to the naming. “Excel2023050506 00 36.xlsx” *(yyyymmddhh mm ss).
This has worked fine, until the file contained more than 30 000 rows that seems to be the limit, despite its an excel file…
Note: If I connect a query to the latest file directly, it works fine, but not when using this dynamic way.
I’m quite new to power query and searching for an answer 🙂
I created a test folder with 30,000+ excel files and my steps are as follows for your reference.
Get data --> folder --> transform data --> select Name column and right-click --> Sort Descending
Keep the first row;
Power bi Desktop [Version: 2.116.622.0 64-bit (April 2023)
Best Regards, Gao Community Support Team
If there is any posthelps, then please considerAccept it as the solutionto 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!