Export Tables to Excel

Hello embarloIT,

 

Users cannot export data directly to Excel from a report shared via Publish to Web.

 

To enable exporting, you can use Power BI Service sharing with proper user permissions and enable the Export Data feature.

However, please note that I wouldn't recommend Publish to Web for sensitive data because it makes the report publicly accessible without restrictions.

 

Perhaps, consider using row-level security (RLS) for better control over who can view and export data.

 

Here's a resource worthwhile exploring: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop

 

Hope this helps.

Hi Syndicate_Admin ,

 

As a side note, if you have a Power BI Pro license and have generated a web link for users to access the report without registering, they will not be able to export the tables to Excel. exporting data from a Power BI report to Excel requires that the user has a Power BI Pro license or that the report is hosted on Power BI Premium capacity.
Users without a Power BI Pro license will not be able to view or export the data. The only other option is to use Power BI Premium, which allows users with a free license to view and export reports.

 

For more details, you can refer to below document:

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.