Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
When I export the table from the Power BI to Excel as summarized data then Excel does not let me open it . But when I do the regular export then I can open the data in Excel.
Is there any Excel setting that I need to fine tune to be able to open the summarized data export ?
Hi @ForgotID
I have not seen that happen in the past. It might be a bug in the Power BI Service. Maybe you can use the regular export and try again in a few days?
Thanks for taking time to respond to my query. Since my co-coworkers are able to export the summarized data I rule out the possibility of Power BI Service error. Otherwise they would not be able to export. I am of the opinion there must be something in my Excel
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!