Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
monishachandi
New Member

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!

2 REPLIES 2
v-zhangti
Community Support
Community Support

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.

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!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors