I understand that a workbook uploaded into Server that has an Excel extract won't necessarily get refreshed in Server even when a Schedule is set in place. Is there a way around this? The actual Excel metadata only needs to be updated once/twice a week but I want the rest of the workbook which has SQL Server data to still update on a daily schedule.
I was thinking of producing a .tde file using Python from the Excel file and adding that tde instead of the Excel extract and publishing to Server within the workbook. Will this work? The only other caveat is that I only have a Desktop license and I thought I read somewhere that this might be possible but I can't find the original source.