Unable to use Web Queries to import into Excel Tables

Question

I'm running Office365 subscription of Excel (16.62) and would like to import some data from an internal web service. I've created a iqy file with the information below and when I run Run Web Query and select this file the option for use table is disabled. I'm able to import the data into a new worksheet or range but would like this data in a table. Is there a format Web Query needs to use tables?

report.iqy

WEB  
1  
http://127.0.0.1:5000/test/report  
  
Selection=1  
Formatting=None  
PreFormattedTextToColumns=True  
ConsecutiveDelimitersAsOne=True  
SingleBlockTextImport=False  
DisableDateRecognition=False  
DisableRedirections=False