Mar 30, 2017 Open Power BI Desktop, and click Get Data, then click Web. If you are using Excel (with Power Query Add-In installed) you can find the Web connector in the Power Query tab. If you have Excel 2016, click Data – New Query – From Other Source s – From Web. We will use Power BI Desktop in this tutorial, but the steps are the same in Excel. Excel for the web looks a lot like the Excel desktop app. However, there are some differences to be aware of. For example, not all file formats are supported, and some features may work differently than the desktop app. This article explains these differences. File formats that are supported in Excel for the web. Excel workbook files (.xlsx).

• When you open a Microsoft Excel workbook in the browser, the workbook opens in a Web-based viewer or in a Web-based editor (if you are using Excel Web App). This viewer and editor support most features of an Excel workbook, but not all. In addition, they support some features differently than the Excel desktop program.
• Dec 02, 2020 Web browser instance: No: Web browser instance: Enter or choose the variable that contains the web browser instance to work with: UI element: No: WebControl: Select the button to press: Wait for page to load: N/A: Boolean value: True: Specify whether to wait for the new web page to load completely after pressing the button: If a pop-up dialog.

Symptoms

In Microsoft Excel, when you create a Web query from a site that uses the Secure Hypertext Transfer Protocol (https://), you may receive an error message that resembles the following error message:

Unable to open
address. Cannot download the information you requested.

Note In this message, address is the Uniform Resource Locator (URL) of the secure Web page that you are trying to connect to.

Cause

Web Browser Web Browsers Web Queries In Excel Online

This issue occurs when Excel cannot initiate a connection because of the settings on the secure Web server.

More Information

To test whether Excel is able to connect to a particular Web page, follow these steps:

1. In Microsoft Office Excel 2003 or in Microsoft Excel 2002, click Open on the File menu.
   In Microsoft Office Excel 2007, click the Microsoft Office Button, and then click
   Open.

2. In the File name box, type the Uniform Resource Locator (URL) of the secure Web page that you want to open, and then click Open.

Web Browser Web Browsers Web Queries In Excel

If you cannot open the Web page, Excel cannot connect to the secure Web page, and you cannot create a Web query.