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

That link doesn't occur to be active currently, but what happens when you double click on that file icon? Power Query may detect the data format and open it correctly for you.

 

Pat

StarTechC2G's avatar
StarTechC2G
New Member
3 years ago

When I click on the link in Power Query it does nothing.  When I click on the link on the website, it downloads to my computer as an excel file.

  • 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?