Data showing up in Excel but not Power Query Editor

I have an Excel spreadsheet that I am trying to reference in a PBIX file, but whenever I make any changes to the file, such as add a constant line to the graph or change the filtering, I can no longer see the data in the Power Query Editor. There is data in the Excel spreadsheet, but it does not show up in the Power Query Editor. I have referenced several posts, including this one, but nothing seems to be working. Both of the columns that are not showing up in the screenshots, in addition to the other columns that aren't showing up in the Power Query Editor, are formula-based in Excel. 

I have tried refreshing the dataset in the desktop service, and that did not show the data. One of these screenshots is from the Excel spreadsheet which clearly has data, and the other one is from the Power Query Editor which is showing no data.