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, and updated as "File_02132023.xlsx ". I wrote the query "dynamicDate" to update the file's suffix weekly so that it updates to the correct date, and this works great in desktop but not in PBI service. Below is a sample of the beginning of the code.
Source = Excel.Workbook(Web.Contents("https://xyz.sharepoint.com/sites/file/" & dynamicDate), null, true)
Is there a way to alter this code so that I can refresh the dynamic data source in PBI Service?