What is the maximum pixel size or dimensions I can set for the canvas?

The maximum pixel dimension is 8,000 x 8,000 pixels. In the download options panel, you can change the export size to 5x, which would allow up to 40,000 pixels.

Alternatively, you can download your project as an SVG vector file which would allow you to scale the image to any size without losing quality.