Figure A shows a simple data set of several columns and rows.
Tables("My Table") sql Cmd = New Sql Command("INSERT INTO My Table (Col1, Col2) VALUES (@Val1, @Val2)", sql Conn) With sql Cmd . It might also mean a high risk for a Data Integrity bug like in this example where the data is set directly.Refresh the pivot table or change the data source to update the pivot table with the applied changes. If you change any of the text or numbers in your data set, you need to refresh the pivot table. This page describes how to update data in Big Query.Note that DML in Big Query has some limitations and known issues.A good design will accommodate most growth and changes, but often, you find yourself working with a data set that doesn't conform well to what you need to do.