Skip to main content

Power BI

Needs Votes

Dynamic table visualization

Vote (3) Share
Arya's profile image

Arya on 18 Mar 2017 23:38:36

Here I have a query that populates result sets dynamically by taking an input parameter.Now the result sets does not have equal number of columns neither they have same column name.So , while using that query to visualize a result set in a table,when I pass another value for the parameter in the query,it creates different result set and as the columns of the new result set is not included in the table value fields,the table view gets invalid. And I have to show result of the query in same visualization.

Is it possible to have a visualization on Report interface that acts just like what Data viewer pane does,i.e., it always shows output of the query whatever the result set is,like a flexible table that adapts to it automatically,or like the Data viewer pane.