Powerbi Export to Excel Option

Hi,

I am assuming, you want to export table data from a published report in Power BI Service.

You can export tables directly from Table visuals.

Click table -> "..." -> "Export Data" ->Popup:

But, make sure data export is enabled in Tenant Settings:

• Admin Portal → Tenant Settings
• Enable Export data
• (Optional) Enable Allow live connections to export data if using semantic models

Once enabled, users will be able to export data directly from table visuals.

Hi,

This happends because the report is embedded using "Publish to web" option. Power BI disables export in this mode for security reasons as the reort is publically accessible.

You can share it via app OR you can use embed with "website or portal" option OR Power BI embedded will also work with authentication.