Forum Discussion

Lijie's avatar
Lijie
New Member
3 years ago

Power Bi Export Data as Summarized Data-downloaded table name changed

On 24th Jan 2023, I exported a report as summarized data and the downloaded table column titles looked like below, which remained the same for the past years.   However, on 26th Jan 2023, w...
Need Help
kevingauv's avatar
kevingauv
Advocate III
3 years ago

Microsoft introduce a new way to export data last week. This new option is the now the default one and will keep a live connection between your Excel and the Report.

You'll need to chose the second option in the dropdown list now to use the "old/normal" way to export data into Excel.

Regards

  • AliceW's avatar
    AliceW
    Power Participant
    3 years ago

    Kevin, you're a lifesaver!

    Do you know how to stop this first horrid option from even being displayed?

    • kevingauv's avatar
      kevingauv
      Advocate III
      3 years ago

      I looked for this option myself and I didn't find any.

      Other thread in the forum are about the same and many peson asked for the same (disable this option).

      Maybe Micorsoft will add an option eventually...

      • AliceW's avatar
        AliceW
        Power Participant
        3 years ago

        What's particularly annoying is that it's the DEFAULT one! And you know regular users just want their beautiful table and will have trouble remembering this option.

  • taniastefanie's avatar
    taniastefanie
    Regular Visitor
    3 years ago

    but this does not completely fix the problem since it does not respect the name of the columns that we change in the dashboard. The user wants to use the table with the name we gave them in the table