Hi @Naila
How you are posting the data to SAP ? Is it manual or Automation ?
Here multiple tables are dynamic, number of tables depends on Period and number of records.
As per my knowledge we can’t create tables dynamically, The only way we can create multiple tables in one shot is selecting from Data Source.
I’ve created a column Files, you can create multiple tables MANUALLY by coping the query and apply filter on this filed.
Now each table has Max 998 lines.
Split table to multiple tables.pbix (654.1 KB)