topic Re: Can not see .xlsx option while data export in Developer

Can not see .xlsx option while data export

AnkitSingla — Sun, 25 Jul 2021 03:51:01 GMT

I can not see the xlsx option while doing data export.

Please find the snapshots below:

Re: Can not see .xlsx option while data export

Fowmy — Sun, 25 Jul 2021 07:21:50 GMT

@AnkitSingla

You need to turn on the Export to Excel option from the Admin Portal > Tenant Settings.

If you do not have the right to do so, request your Power BI administrator to turn it on.

Re: Can not see .xlsx option while data export

Anonymous — Tue, 27 Jul 2021 01:59:54 GMT

Hi @AnkitSingla ,

Frist in Power BI Desktop, select File > Options and Settings > Options, then select Report settings under CURRENT FILE. Find Export data section to select the option "Allow end users to export both summarized and underlying data from the service or Report Server" if you need to export both summarized data and underlying data.

In Power BI Service, please find the related report and select the option "Settings" just as shown in Settings image. It will open report setting page, please make sure that you select the option "Summarized data and underlying data" under Export data dropdown list if you want to export both Summarized data and Underlying data and click "Save" button to save this setting...

Select Settings

Report setting page

Best Regards

Re: Can not see .xlsx option while data export

AnkitSingla — Fri, 30 Jul 2021 09:42:51 GMT

@Fowmy Thanks. I am checking with Power BI Administrator for this setting.

Re: Can not see .xlsx option while data export

AnkitSingla — Fri, 30 Jul 2021 09:46:13 GMT

@Anonymous I already had taken care of this option . Looks like Power BI administrator need to turn on Export to Excel option from the Admin Portal > Tenant Settings.