Forum Discussion
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...
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
How do I reward you with Kudo's ????? ( This is new for me)
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.