Generic table visual

[jammin]

I have a simple Power BI Desktop query that produces a table data dump, based on a parameter value that specifies the table name:

let
  Source = Odbc.Query("dsn=" & #"parm-DB2SSID","SELECT * FROM " & #"parm-TableName" )
  in Source

The query works fine in the Power Query Editor.  It  returns the data for the specified table, regardless of the number of columns the table may have.   

How can I set up a visualization for this query such that, whether the parameter specifies a table with 10 columns or a table with 2 columns, it presents the specified table's content as a display report?   The intended tables are small in terms of number of rows, but I'd add a clause to limit the data returned to 50 or 100 rows to avoid a SELECT ALL on a large, unintended table.   I understand that scrolling needs will vary, depending on the number/size of columns associated with the table requested...  that is completely acceptable becasue this particular requestable report is intended for on screen use only.

[TomMartens · Accepted solution]

Hey,

unfortunately it's not possible to populate visuals in a way like "SELECT * COLUMNS FROM TABLE ON COLUMNS USE TABLE_VISUAL"-

Regards,

Tom