New Schema causing refresh of data to fail

[apbiuser]

The schema for one of our database table sources changed to include additional columns.  How/where do I go into the Power BI desktop solution to update the Editor so that it will just bring in the additional columns.  We do not care about them but we do not care if it brings them in.  Please help.    

[v-juanli-msft]

Hi @apbiuser 

If you add columns in the data source, then click on "refresh" in Power query(Home->Transform data) or refresh in "Home",

it would update new added columns into Power bi and show on your tables.

But if you want to only update and show new added columns (lose the original all columns), it seems impossible in Power bi directly.

It may be possible with some workarounds.

If it is in this case, please let me so i will work to find a workaround.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@apbiuser you need to click on transform data, in power query, select the table and click refresh, and you will see the columns and once it is all there, close and apply and it will be loaded into the model.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡