Forum Discussion

Hansdecocq's avatar
Hansdecocq
Frequent Visitor
4 years ago
Solved

How to extract table name from WEB import

Hey “POWER BI boy’s and girls” 😊   What is my help-question? How can I extract the generated name (see content “Web.BrowserContents” returned by the first the power query step?    What is the s...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    The name of the table comes from a caption tag buried in the Web.BrowserContents text.

     

    In this particular case, you can extract it like this:

    let
    Source = Web.BrowserContents("https://www.belastingdienst.nl/wps/wcm/connect/nl/douane_voor_bedrijven/content/hulpmiddel-wisselkoersen"),
    TableName = Text.BetweenDelimiters(Source, "<caption>", "</caption>")
in
    TableName
Hansdecocq's avatar
Hansdecocq
Frequent Visitor
4 years ago

Thanks for this (quick) reply. The first thing I'll do tomorrow is try this 🙂

Hansdecocq's avatar
Hansdecocq
Frequent Visitor
4 years ago

How do I reward you with Kudo's ????? ( This is new for me)

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    You can hit the Thumbs Up button on any message that deserves Kudos and click the Accept as Solution button for the message that resolved your question.