Forum Discussion
How to display rows from datasets with variable schema in a single table visual?
- Anonymous8 months ago
Hi Divyanshu1504 ,
Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you danextian and HarishKM for your helpful response.
Power BI table visuals require a fixed schema, so columns cannot be created dynamically at runtime. The supported way to meet your requirement is to use Field Parameters. Define all possible columns once in a field parameter, then use a Dataset–Column mapping table to control which columns are visible based on the selected dataset. When a user selects Dataset A or B, only the mapped columns appear in the table. This approach simulates dynamic columns and is the simplest and recommended workaround in Power BI currently.
Thank you.
Hi Divyanshu1504 ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.
Thank you.