Automate dataset loading

[ankurbajaj]

Hi I am new to power bi. I have folder which contains excel data file for Jan23 which i have loaded in power bi by selecting folder path in getdata option.

Now when i put new file in same folder for Feb23, the datset doesnot appear in power bi. Please help.

[Ashish_Mathur]

Hi,

Follow the steps shown in this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube

[lbendlin]

show a sanitized version of your Power Query code.