Forum Discussion

Missippy's avatar
Missippy
Helper I
1 year ago
Solved

Source page keeps getting small changes

I run power queries every morning where I download a lot of data from a webpage. The source keeps making these small changes, like adding a column to the page I am trying to download. When they do, m...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Missippy,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community.

     

    Can please try below M code to adopt to any changes

    let
    Source = Web.Page(Web.Contents("https://www.baseball-reference.com/teams/tgl.cgi?team=NYY&t=p&year=2025")),
    AllTables = Source[Data],

    // Convert all columns in all tables to text
    ProcessedTables = List.Transform(
    AllTables,
    each Table.TransformColumnTypes( _,List.Transform(Table.ColumnNames(_), each {_, type text}))),

    // Optional: Combine into one big table (if structures are the same)
    CombinedTable = Table.Combine(ProcessedTables)
    in
    CombinedTable

     


    Kind regards,
    Prasanna Kumar

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Missippy,

 

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

 

Best regards,

Prasanna Kumar

  • Missippy's avatar
    Missippy
    Helper I
    1 year ago

    here is a screen shot of the top of the M code:

    here is the bottom

    there are many lines of m code in between

    • ralf_anton's avatar
      ralf_anton
      Resolver I
      1 year ago

      Hallo Ich'm nicht Prasanna, aber Ich'Ll Antwort jedenfalls... Etikett das ganz M-Code, du verschickst und ersetzen es mit das Eins Prasanna verschickt auf Freitag in Post #9.

      • Missippy's avatar
        Missippy
        Helper I
        1 year ago

        so just to be clear, delete that whole page of code and paste that line over it?