Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 16 | |
| 11 | |
| 11 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 41 | |
| 36 | |
| 35 | |
| 35 | |
| 20 |