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,

 

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

  • Missippy's avatar
    Missippy
    Helper I
    1 year ago

    Prasanna, I tried the above code you posted just now. It worked but it is telling me I can't do it because it will move cells in a table on your worksheet. I am not sure why it would move cells since I am ignoring columns not deleting. Is there something I can do for this? To explain, I have each teams table beside each other. 

    • ralf_anton's avatar
      ralf_anton
      Resolver I
      1 year ago

      Hallo

       

      Wahrscheinlich laden Sie die Daten in eine Tabelle, in der bereits eine Tabelle vorhanden ist. Laden Sie die Daten in eine neue Tabelle.