Forum Discussion

monishachandi's avatar
monishachandi
New Member
3 years ago

Dynamically add new columns to table visual

Hello,

 

I have a table visual in my report. Is there any API or any other way to ensure that any new columns added to my data model can be automatically added to the visual as well?

 

Also, is there any way to Select All columns from the dataset in one go while creating the table visual?

 

Thank you!

Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, monishachandi 

     

    Yes, you can use the Power BI API to dynamically add new columns to a table visual in your report. You would need to use the "updateVisual" method to modify the existing visual and add the new columns.

     

    Regarding your second question, yes, you can select all columns from your dataset in one go while creating a table visual. To do this, simply drag and drop the table from the Fields pane onto the canvas, and all columns will be added to the visual by default.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • monishachandi's avatar
      monishachandi
      New Member
      3 years ago

      Hello,

       

      Thanks for your response. I am not able to find any method named updateVisual in the documentation. Please share the link for the same.

       

      Thank you!