Forum Discussion

ForgotID's avatar
ForgotID
Icon for Advocate I rankAdvocate I
3 years ago

Summarized Data export to Excel

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 ?

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    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?

    • ForgotID's avatar
      ForgotID
      Icon for Advocate I rankAdvocate I
      3 years ago

      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