Power BI

Question

Hi,&nbsp;&nbsp;Just seeking some help getting data from multiple files on a HTML web page via Power BI.&nbsp;&nbsp;&nbsp;Any help could do.&nbsp;Cheers

greg_deckler · Answer

Going to need some additional detail to help, are you referring to files linked from a web page? What kinds of files?

prat91 · Answer

HI&nbsp;Greg_Deckler,&nbsp;Thank you for attempting to help me out.&nbsp;The files are Tables in xls format stored on a web pages. I need to get those files straight into power BI without downloading them manually. This is so data refresh can work.&nbsp;&nbsp;Look forward to your response.&nbsp;&nbsp;

greg_deckler · Answer

You would use the web connector and if they are true tables on the web page, they should show up in the navigation.

prat91 · Answer

I have tried that, but unfortunately it doesnt work, even once I have expanded or drilled down on the columns. From my understanding there is a need to create a parameter and function, but not sure on the process of doing so.&nbsp;

stretcharm · Answer

Try this&nbsp;let
    Source = Excel.Workbook(Web.Contents("go.microsoft.com/fwlink/?LinkID=521962"), null, true),
    financials_Table = Source{[Item="financials",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(financials_Table,{{"Segment", type text}, {"Country", type text}, {"Product", type text}, {"Discount Band", type text}, {"Units Sold", type number}, {"Manufacturing Price", Int64.Type}, {"Sale Price", Int64.Type}, {"Gross Sales", type number}, {"Discounts", type number}, {" Sales", type number}, {"COGS", type number}, {"Profit", type number}, {"Date", type date}, {"Month Number", Int64.Type}, {"Month Name", type text}, {"Year", Int64.Type}})
in
    #"Changed Type"I connected to the site using the web connector, then clicked right mouse menu over the document and Selected Excel.&nbsp;If you have lots of documents you can use functions to loop over the documents. There are several posts that explain how.e.g.https://powerbi-pro.com/iterating-over-an-unknown-number-of-pages-in-power-query/&nbsp;Phil&nbsp;&nbsp;

Forum Discussion

Power BI

9 Replies

Related content

Power BI License

Image display in Power bi report

Power Apps for Power Bi

Power BI Training

power bi