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

[Lijie]

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, when I exported the report as summarized data and the downloaded table column titles changed to below ones ( each with table Name[Column Name] or table name[measure Name]), this happened to all my reports. 

has Power bi changed the layout of export data as summarized data?

[Sidi]

Although Keeping connection is good feature but rename the user friendly column name is a very big sin and confuse not only the users but also the developers, I hope that they make both together keep connection and name of columns added by developers.

Now the workaround is in kevingauv reply but hopefully to see soon both to gether connection and name of columns

[Lijie]

Thanks. 

[kevingauv]

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

[taniastefanie]

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

[AliceW]

Kevin, you're a lifesaver!

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

[kevingauv]

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]

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.