Forum Discussion

SHAYAN1350's avatar
SHAYAN1350
Copper Contributor
Nov 06, 2020

transfer data and hyperlink from web to power quary

hello Is there a way in Power Query to transfer data from the web, the hyperlinked text is transferred to Power Query in the same conditions and works? and for that how can i extract URL code from ...
excel
SHAYAN1350's avatar
SHAYAN1350
Copper Contributor
Nov 07, 2020

SergeiBaklan 

Thank You Baklan

 i can't do it in excel but i try to check it in Power BI

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 07, 2020

    SHAYAN1350 

    Yes, sorry, Html.Table() is not available so far in Excel. Parsing of page as text which Gil suggested could work, but you shall to know which kind of links you'd like to extract and how to clean them.

    • SHAYAN1350's avatar
      SHAYAN1350
      Copper Contributor
      Nov 08, 2020

      SergeiBaklan 

      Thanks Baklan
      I was looking for a way to create an Excel file that extract all category of formula in excel from below link by power query, that I can update the ability to access all information and examples of formulas. if it possible help me to do it please.
      https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb

Resources