Hi @Dharshinika-FT ,
Thank you for reaching out to Microsoft Q&A for this question.
I am a bit unclear of the type of automation being done using Selenium and Azure Workbook here, however, below are some information about the query based on my understanding:
1. Automating the authentication without disabling MFA - this disables the purpose of MFA. Multifactor authentication (MFA) adds a layer of protection to the sign-in process. When accessing accounts or apps, users provide additional identity verification, such as scanning a fingerprint or entering a code received by phone. In the current scenario, since the account used for authentication will be used in automation, this account should be excluded from MFA. Please refer to this link for more details - User exclusions from Conditional Access
2. Automate azure workbook using selenium - I assume that you are trying to read content from Workbook using Selenium. Please correct me if I misunderstood something here. The Azure workbook provides a flexible canvas for data analysis and the creation of rich visual reports within the Azure portal, and it can extract data from multiple data sources as available here - Azure Workbooks data sources. I would advise you to look at the data source and queries being used in Workbook and query data directly, instead of doing automation to access workbook.
Update 06/23
You could also Print a workbook or save as PDF.
Please let me know if you have any questions.
---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.