Forum Discussion
Query to fetch data based on date
Hi, Pretty new to PowerBI and I would need some assistance. I need to query data from an Excel file, based on the folder & file name. I have a folder X, which has yearly folders inside, t...
I have a folder XDon't do that - it will require a gateway. Instead, place your files on a SharePoint / OneDrive and then use the "Sharepoint Folder" connector. That will allow you to dynamically identify the required Excel file and then pull the data from there. "Skip the query" is not a thing, you MUST return something at the end of the Power Query - you could either return the latest available data, or a placeholder.