Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Hey,
unfortunately it's not possible to populate visuals in a way like "SELECT * COLUMNS FROM TABLE ON COLUMNS USE TABLE_VISUAL"-
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |