Is it possible to dynamically update the source data

[Williamlima]

Hey guys 

I need some help with a dynamic query in power BI,  heres the following example of a URL:

http://example.example.com.br:8092/LogsBus/ServidorBusNet/20200115_06_Thread_EnvioDFTrans.txt

A new URL is generated every hour and the number after the date referes to all the info generated in that  specific hour of the day (06:00 to 06:59) which means i'll have 24 URL's every day. 

The problema is, how can i consult all the data from those files logs? is there light at the end of this tunnel?

Any help will be very apreciated.

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, i choose Excel as as source for you to refer to:

You can change its file path by setting variable to get current day's hour:

And the file name shows:

Here is my test pbix:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi

[Williamlima]

@v-gizhi-msft  Nice, thank you very much