Forum Discussion
Create table visual with all columns at once
For quick analysis, it would be very helpful to create a table visual for all columns of a table.
What do you think?
3 Replies
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,
Microsoft has a funny view of the word "currently". Unbelievable that this is not easy to do.
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.
