Forum Discussion

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

     

     

    • prat91's avatar
      prat91
      Frequent Visitor
      8 years ago

      Hi Phil, 

       

      Yes I have to loop over multiple files. 

       

      How would I go about doing that?

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        8 years ago

        Hi prat91,

         

        Here is a good article about how to iterate over multiple pages of web data using Power Query for your reference. :smileyhappy:

        1. Creating the initial query to access a single page of data
        2. Turning the query into a parameterized function
        3. Invoking the function for each page of data you want to retrieve

        Regards