Forum Discussion

WhitmarkEA's avatar
WhitmarkEA
Frequent Visitor
2 years ago
Solved

Is it possible to pad a table with empty rows?

I have a dataset (SharePoint list) which self-builds over time via user input and Power Automate flows.  I currently bring the SP list into Power BI and perform some steps and cleansing in Power Query before visualising in Power BI.

 

I am in a position where once a month, I need the table to be padded with a numer of blank rows, for downstream processing.

 

i.e. Currently, every month I export a copy of the table for use in another piece of software - which expects a table with specific dimentions.

 

Is it possible to pad a table to a specific number of rows, with the target number of rows coming from another table in the report (i.e. it's already loaded into Power Query)?

 

  • Hi,

     

    if you want 1000 rows

    = YourSource & Table.FromList(List.Repeat({null},1000-Table.RowCount(YourSource))) 

     Stéphane

1 Reply

  • Hi,

     

    if you want 1000 rows

    = YourSource & Table.FromList(List.Repeat({null},1000-Table.RowCount(YourSource))) 

     Stéphane