Forum Discussion

FAMH's avatar
FAMH
Frequent Visitor
3 years ago

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 file name does not excist because the previous was deleted and a new one excist . Is there a solution or an effecient approach knowing , I do not have the option to get the excel file name not changing  

 

 

Best Regards 

Need Help
Show and Tell

2 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    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

     

    • FAMH's avatar
      FAMH
      Frequent Visitor
      3 years ago

      Thank for taking time to answer and your help . There is multiple files in the forlder . 

       

      Best Regards