Forum Discussion
niyati_61
Helper III
Helper IIIPower BI: How to import weekly data?
Hi all, Currently I'm builing a Power BI Report for Engineering Progress Report data. Regarding the Data: I get 5 Relevant Engineering Excel Files weekly. This Engineering data gets updated e...
amitchandak
Super User
Super Userniyati_61 , One of the ways is to have separate excel in a separate folder and configure folder load.
Also need to explore -https://wkrzywiec.medium.com/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711
Can give details like how many excel, each excel how many sheets are used etc