How to display a rotated table over several pages?

Questions
4

I know that this is marked as solved but for me this doesn’t seem to work. My code looks basically like this

#show figure.where(kind: table): set block(breakable: true)

#let table_x = csv(
  "table.csv",
)
#rotate(
  -90deg,
  reflow: true,
)[
  #figure(
    table(
      columns: table_x.first().len(),
      table.header(repeat: true, ..table_x.first()),
      ..table_x.slice(1).flatten(),
    ),
    caption: [My Caption.],
  )
]

but the table does not split across pages.

I want to rotate the table not the pages themselves due to headers/footers in my document.