Web query not working

[Namya]

Hi All,

I am trying to set up a web query from SA360 (Search ads 360) into excel and am unable to click the sign in box and sign in.
This is happening for any other data source as well so looks like an excel issue.
Would be great if someone can guide me on this.

Thanks.

 

[severynm]

I could be wrong, but I believe that the Web View is just a preview of the web page - it is not interactive like you are trying to do. You could be seeing that because you have not supplied the proper credentials to access the specific web page.

Right after you choose Get Data → From Web and enter the URL of your data, you should be presented with a dialog to enter credentials to access the webpage. Otherwise, you can update credentials via Get Data → Data Source Settings.