Forum Discussion
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 Figure 1 and pasting it into the get data option in Power Bi does not read the list in Query (Figure 2).
I simply just want to create a table with the list provided. If you click the link address, it will download as a Microsoft excel file.
(Figure 1)
(Figure 2)
4 Replies
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
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.
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
