Forum Discussion

StarTechC2G's avatar
StarTechC2G
New Member
3 years ago

Problem with importation data link from the web into query

Hello, I am trying to import the daily list of EPA's list of registered companies/facilities. The link to the website is HERE.  My problem is that copying the link address from the circled link in Fi...
Need Help
ppm1's avatar
ppm1
Solution Sage
3 years ago

This approach seems to work.

let
    Source = Excel.Workbook(Web.Contents("https://cdxapps.epa.gov/oar-otaq-reg-III/rest/public/reports/Part80FuelsProgramsList")),
    Sheet0 = Source{[Name="Sheet0"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet0, [PromoteAllScalars=true])
in
    #"Promoted Headers"

 

Pat

StarTechC2G's avatar
StarTechC2G
New Member
3 years ago

Where do I enter this?