I have a google sheet with 2 tabs
https://docs.google.com/spreadsheets/d/1AN-qgXPNi7zToILqSM7JoEy0aojMfO8nH9CKXyNjKaA/edit?usp=sharing

Tab 1: Data Source Sheet (this is connected to a external big query data source, this sheet id is 1333600852)

Tab 2: Grid Sheet (This contains static data, this sheet id is 449941681)

I want to display the sheets with specific range mentioned in a hmtl format

Tab 2 (works): https://docs.google.com/spreadsheets/u/0/d/1AN-qgXPNi7zToILqSM7JoEy0aojMfO8nH9CKXyNjKaA/htmlembed?&gid=449941681&range=A1:A2&widget=false&chrome=false&headers=false

Tab 1 (doesnt work): https://docs.google.com/spreadsheets/u/0/d/1AN-qgXPNi7zToILqSM7JoEy0aojMfO8nH9CKXyNjKaA/htmlembed?&gid=1333600852&range=A1:A2&widget=false&chrome=false&headers=false

If I remove a range parameter it works, but I wanted a custom range to be passed to the url
https://docs.google.com/spreadsheets/u/0/d/1AN-qgXPNi7zToILqSM7JoEy0aojMfO8nH9CKXyNjKaA/htmlembed?&gid=1333600852&widget=false&chrome=false&headers=false

Does anyone know the URL parameter that can render the data source linked sheet as html
Note: The sheet isnt published, This is a sheet with anyone with link can view and hence I dont want to publish entire sheet using a sheets publish wizard.