Solved: Query refresh with field changes

DHawes · ‎11-18-2016

My data model is currently loading an xml file each day. It is a complete reload, not incremental.

The xml is output from a postgres database and I do not want to link directly yet.

I have one field/attribute in the xml file that is included on some days, but not others.

I have included in my data model, but when it does not exist in the xml input, the dataset refresh fails.

Is there someway to bypass this error?

Thanks

Dwight

dkay84_PowerBI · ‎11-18-2016

I am interpreting what you are saying as your query breaks when a field that you reference in your query is not present. That means that somewhere in your query editing steps you reference that column (either directly or indirectly) and thus it cannot find the field that is missing and it throws an error.

Again, I'm not sure if this is the situation but try looking at the steps in your query and see if it breaks at the source or somewhere in the applied steps. If it is a step, then you can do some error handling to work around this. Take a look at this example:

https://blog.crossjoin.co.uk/2015/02/26/handling-added-or-missing-columns-in-power-query/

View solution in original post

dkay84_PowerBI · ‎11-18-2016

I am interpreting what you are saying as your query breaks when a field that you reference in your query is not present. That means that somewhere in your query editing steps you reference that column (either directly or indirectly) and thus it cannot find the field that is missing and it throws an error.

Again, I'm not sure if this is the situation but try looking at the steps in your query and see if it breaks at the source or somewhere in the applied steps. If it is a step, then you can do some error handling to work around this. Take a look at this example:

https://blog.crossjoin.co.uk/2015/02/26/handling-added-or-missing-columns-in-power-query/