I have embedded Looker Studio as a dashboard for a report, but I'm unable to export the data by right-clicking on the chart or by selecting 'Export' from the 'More options' menu.
I am using an Azure database.
While I can export data successfully from the official Looker Studio page, I cannot do so when the dashboard is embedded using an iframe.
I expect to be able to export the data from the embedded iframe without needing to log into any Gmail account.
Update:
I found that exporting to Google Sheets works well. however, my goal is to export directly to Excel.
Already set sandbox="allowfullscreen sandbox="allow-storage-access-by-user-activation allow-scripts allow-same-origin allow-popups allow-popups-to-escape-sandbox" and can export data if i use the iframe src url directly.
Add this to your iframe sanbox allow-downloads