Scheduled Refreshes on Cloud Error with Data Source Connectivity

Hi, 

I created a report that has a data table (sql database) that pulls from another data table (static excel file). However, the excel file has since been moved/deleted (not by my doing) and I am unable to run scheduled refreshes due to this. I merged queries in Power Query to basically like a date to see if its a holiday or not. I was wondering if there is a way to basically schedule a refresh without considering this data source?

I googled and this is what I found and attempted but it is not working. I unchecked these boxes in Power Query.

I basically do not need the file to be refreshed at all and Just need my other data sources to be refreshed on the schedule.


Any assistance is appreciated! Thanks 🙂