Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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

prat91's avatar
prat91
Frequent Visitor
8 years ago

HI Greg_Deckler,

 

Thank you for attempting to help me out. 

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. 

 

Look forward to your response. 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

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

    • prat91's avatar
      prat91
      Frequent Visitor
      8 years ago

      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. 

      • stretcharm's avatar
        stretcharm
        Memorable Member
        8 years ago

        Try this

         

        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.

         

        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/

         

        Phil