I would like to pass user id and password in the iframe. So that login screen won't appear.
Is this possible? Please suggest
There is no way to pass credentials in an iframe however, publishing the view with credentials embedded should allow you to publish the workbook and embed in to an iframe without being prompted for login. For more information see:
I hope this helps!