Forum Discussion
Excel file name Chaging in Power Query
[ Spoiler ] Hello Community , I am loading an excel file to Power BI ,sotred in Azure Blob Storage, . This excel file is changing name every Hour .When I refresh data, I get the error the f...
If there is just a single file in that folder, you can use the {0} syntax to get the first record/file (instead of directly referencing the file name). In your query, get to the step that shows the files, hit the fx button near the formula bar and then add {0} to the previous step reference.
Pat
Thank for taking time to answer and your help . There is multiple files in the forlder .
Best Regards