[Solved] Given this Power Query M code snippet, what will be the output type after running it?let Source = Web.Contents("https://example.com/table"), Data = Csv.Document(Source) in Data | Power BI

Power BI - Getting Data

Given this Power Query M code snippet, what will be the output type after running it?

let
  Source = Web.Contents("https://example.com/table"),
  Data = Csv.Document(Source)
in
  Data

AA list of URLs extracted from the web page

BA table containing CSV data from the web URL

CAn error because Csv.Document cannot parse web content

DA text string of the web page HTML

Step-by-Step Solution

Solution:

Step 1: Understand Web.Contents Output
Web.Contents fetches raw data from the URL as binary content.
Step 2: Apply Csv.Document to Parse Data
Csv.Document converts the binary CSV data into a table format.
Final Answer:
A table containing CSV data from the web URL -> Option B
Quick Check:
Web.Contents + Csv.Document = Table [OK]

Quick Trick: Web.Contents + Csv.Document returns a table [OK]

Common Mistakes:

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

Given this Power Query M code snippet, what will be the output type after running it?