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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Asmaa-elsheikh
Frequent Visitor

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 

watkinnc
Super User
Super User

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

 

--Nate


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors