Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I can not see the xlsx option while doing data export.
Please find the snapshots below:
Solved! Go to Solution.
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...
Best Regards
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...
Best Regards
@v-yiruan-msft 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.
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |