cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MonicaElizondo Regular Visitor
Regular Visitor

Help: Export all data table to excel

Hi all!! 

 

I have this question, about power bi service; I have a table with 60 columns and in the report I only show 10 columns, when the information is exported to excel, there is a way to download the 60 columns although the report always shows 10?

 

This is only in the http://app.powerbi.com; not for PBI Desktop.

 

Thanks for yours comments

Greetings

Mónica

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Help: Export all data table to excel

Hi @MonicaElizondo,

 

Here I made a test to export all columns of a table if only part of columns were added in one visual. Firstly, we need to change the columns that were not added into the visual to text type in advance in desktop. Then publish the report to service. After that, we can get all the columns of the table through exporting data of the visual.

 

1.png2.png

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Help: Export all data table to excel

Hi @MonicaElizondo,

 

Here I made a test to export all columns of a table if only part of columns were added in one visual. Firstly, we need to change the columns that were not added into the visual to text type in advance in desktop. Then publish the report to service. After that, we can get all the columns of the table through exporting data of the visual.

 

1.png2.png

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

MonicaElizondo Regular Visitor
Regular Visitor

Re: Help: Export all data table to excel

Frank, 

Thanks for your help, Its work perfect for me.

 

Regards,

Mónica

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,930)