How to choose columns I need to export, instead of default exported columns

[Kelly_Zhu]

Hi Everyone,

When I exported data like below, a table opened. There are so many columns in the table. 

I need only some of them and a lot of columns I need don't appear in the table. 

After I dragged those columns in the table, I can export. However, when I clicked "Export data" again, the columns I added manually disappeared.

Could you give me some advices to solve this issue? I would like to set the columns who can appear and sort the columns.

Thank you in advance!

Regards,

Kelly

[v-jiascu-msft]

Hi Kelly,

That's weird. The columns shouldn't disappear. Did you save the report?

If you export data in the Power BI Service, you will see two options, Summarized data and underlying data. It could help. 

Can you give more details about how to reproduce this issue please?

BTW, we can't choose which columns to export for now. If you want this feature, please create an idea here.

About Exporting data, you can refer to power-bi-visualization-export-data

Best Regards,

Dale

[Kelly_Zhu]

Hi Dale, Thanks for your reply! I have raised a ticket as the same time. The support suggest me to create an idea about this, too. I have created an idea about this issue. Thanks, Kelly