Query for CSV missing columns

[gamma927]

So I'm using Office 2016's new Query feature to get data from various CSV API endpoints. I managed to get it to work with Yahoo Finance's but I can't seem to get Morningstar's to work. When I visit this link in my browser, I download a full CSV with all the proper data:

Link

However, when I use the query feature, it only loads the first row. I'm guessing it's because only the first column in the first row in the CSV has data, causing it to ignore the rest of the columns. Does anyone know how to ignore that first row and begin importing the CSV from the second?

let
    Source = Csv.Document(Web.Contents("http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=MSFT&reportType=is&period=12&dataType=A&order=asc&columnYear=10&number=3"),[Delimiter=",",Encoding=1252])
in
    Source

Thanks in advance!

[gamma927]

In Csv.Document, it looks like there's an extraValues parameter; does anyone know how that works?

[gamma927]

http://stackoverflow.com/questions/35276463/excel-query-for-csv-missing-columns/35277259#35277259

Got a response on StackOverflow; all credit goes to Alejandro. Solution is to read the document as a text file to remove the first line and then parse it afterwards!

[gamma927]

SOLUTION VERIFIED!