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

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.