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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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 

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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