Update Report with latest worksheet

[francobonelli]

Hi everyone

I am pretty new to Power BI and have a little issue I need some help with :).

My data is taken from an auto generated excel sheet that is located in a specific folder location.

The data list gets updated everyday and makes a new worksheet each day in the folder with today's data.

I only need to display certain data - 

I have made a visualisation of just today's data as a test, but how is it possible to set it up that my data set will update each day with the data from the newest created worksheet in the folder?

Any help that anyone can offer is greatly appreciated 🙂

Regards,

Franco.

[amitchandak · Accepted solution]

@francobonelli , refer if this can help

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

[francobonelli]

yes, thank you Amit. That worked great. Thank you 🙂

Regards

Franco