Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
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.
inserts or appends?
I mean inserts
Wherever the step with the error is, try adding ExtraValues.Ignore as the final parameter to the Table Function in that step.
--Nate
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
42 | |
27 | |
14 | |
13 | |
13 |