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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply

Data Source Update

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

 

6 REPLIES 6
v-jingzhan-msft
Community Support
Community Support

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!

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 ?

 

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
Super User
Super User

inserts or appends?

I mean inserts 

Anonymous
Not applicable

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

 

--Nate

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors