Data Source Update

[Asmaa-elsheikh]

Hi All

I am working on a dynamic data & it is connected to power bi, but when someone inserts a column, it gaves me an error & refused  to be refreshed, is there any soultion to solve this issue ?

TIA

[v-jingzhan-msft]

Hi @Asmaa-elsheikh 

Which kind of data source are you connecting to? Do you mean someone may add columns to the table ( which you are querying from ) at the data source side? 

If this issue happens after the "Source" step, and you are sure about which columns are needed in your report and you don't need any newly added columns, you can add a step after the "Source" step to select the specific columns by name. Sometimes this will work to resolve this issue. 

You can also try the method suggested by Nate. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Asmaa-elsheikh]

Which kind of data source are you connecting to? Google sheet
Do you mean someone may add columns to the table ( which you are querying from ) at the data source side? Yes 

Actually, somtimes I need these new columns, so what is the best solution?
And if I deleted a column or edit it's name, still gives me an error, should I edit it in the query, so I avoid the errors ?

[lbendlin]

Power Query can handle appended columns in some circumstances. It will most certainly freak out about inserted columns, and in the service it will error out every time.  Refactor your process.

[lbendlin]

inserts or appends?

[Asmaa-elsheikh]

I mean inserts 

[watkinnc]

Wherever the step with the error is, try adding ExtraValues.Ignore as the final parameter to the Table Function in that step.

--Nate