Forum Discussion
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...
Hi jf90
Are you able to copy the file?
If you are you could then copy it to another SharePoint location and part of the copying process is to then rename it?
As to why it does not work, before a refresh starts it checks to make sure that the file is valid, and when the filename is dynamic it cannot check to make sure it exists and that is why it is not allowed currently.
