Forum Discussion

jf90's avatar
jf90
Frequent Visitor
3 years ago

Dynamic data source will not refresh in PBI service

Our organization has a sharepoint file that updated weekly with a new file suffix (File_MMDDYYY). So, for example, the online excel workbook is saved as "File_02062023.xlsx " at the start of one week...
Need Help
GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi jf90 

 

What I would do is to find a way to change the weekly excel filename to be consistent.


For example I would have a process each week which would copy the latest file and rename it to file_CurrentWeek.xlxs


Then you could just use this name in your query?