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.
