Hi Ashwin Venkatesha ,
Thanks for reaching out to the Microsoft Q&A community.
To address the "Request Entity Too Large" error in your Azure Workbook, you can optimize your API calls by filtering and aggregating data at the source to reduce the volume. Structure your queries to process data in smaller chunks and store raw data in external storage like Azure Data Explorer or Cosmos DB for further processing. Make sure you check and adhere to the size limits for Azure Workbooks and the custom endpoint. Additionally, consider using Azure Functions or third-party tools for preprocessing if necessary.
If you found this solution useful, don't forget to upvote and accept it!