Excel web query for password protected sites with pop up reporting

[Joseph Simmons]

I am trying to perform a web query on a password protected site that requires criteria to be filled in to generate a report that is an additional pop up window.  I need the data from the pop up window report.  Anyone have any idea how to do this with the advanced web query in excel 2016?

[#2]

I just got a hold of the company hosting the site and asked for read only rights to the sql database servers and they granted it. problem solved