Forum Discussion
WhitmarkEA
2 years agoFrequent Visitor
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
- slorinSuper User
Hi,
if you want 1000 rows
= YourSource & Table.FromList(List.Repeat({null},1000-Table.RowCount(YourSource)))Stéphane