Forum Discussion
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.
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.
Hello ! Thankyou so much for the support and this will solve the problem but the problem now I am facing is that I can see those three dots on different visuals like slicers etc but not on my table !!
I have already enabled export options from the admin portal settings...
I have another organizational account and in that I can see those three dots and eventually that option to export but not in this one.. 😓
Hi muhammadali0799,
Click on the visual, make sure header icons are turned on for that visual and also more Option under header icon is turned on
Thankyou for your reply ! Yes I have checked it but the problem is I see that option in my Powerbi desktop ! That dashboard is embedded (publish to web) where the option doesn't appear...
