Create table visual with all columns at once

[Anonymous]

For quick analysis, it would be very helpful to create a table visual for all columns of a table.

What do you think?

[v-sihou-msft]

@Anonymous

Currently, we have to select data fields individually to have it rendered in table control. You can submit a feature request like adding "select all" for each dataset on Ideas: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

[ThomasI]

Microsoft has a funny view of the word "currently". Unbelievable that this is not easy to do.

[mike_honey]

I would probably use Excel for this - you can copy a Query definition from PBI Desktop into the Workbook Queries pane of the Power Query Add-In (for Excel 2016 - the Data / Get & Transform / Show Queries).

The result is an Excel Table, which is the probably the ultimate tool for analysing and testing a table of data.