How to add a new column in the existing table

[akj2784]

Hi All,

I have a Oracle table which is already used in the power bi desktop.  Now recently we have added some more columns in the table which I want to use it in the modeling. 

How do I import the new column in the existing table so that I can use that in the report. When I import it , it creates a new alias of the table and imports the entire table. I don't want to do the merge for every addition of new columns. Is there any other way ?

Regards,

Akash

[AnthonyTilley]

in the Query editor select your table and then in the applied step click the cog on the Source (first step)

this will open your query window Where you can alter your query and add in the new colunms

[SivaMani]

Hi @akj2784,

It is pretty simple. Select the particular query in Query Editor. In the right side, you will see the applied steps.

Select the particular query in Query Editor. In the right side, you will see the applied steps.

Double click on the Added items, You will get a pop up to add/Remove fields.

 

[akj2784]

Thanks for the short video. But I am not seeing the Added Items option on the right side. Looks like only when we have any new column in the table in db side, this option will come ? I am getting only those options which were applied by me like, Remove Columns, Rename Columns etc. Since I did not add any new column I am not getting that option. 

Could be very basic thing but somehow I am not able to find. 

Since my table doesnt have any new column as of now, I think I am not getting that option. I was just exploring this feature.

[SivaMani]

Hi @akj2784 ,

Are you using Import or Direct Query?

What is your source?

[Greg_Deckler]

You probably just have to edit your Power Query query. Depends on what you did in your query.

[akj2784]

I did not find the option to edit. I did not do much in the query. Its just the import.. 

[Eric_Zhang]

---

@akj2784 wrote:

I did not find the option to edit. I did not do much in the query. Its just the import.. 

---

@akj2784

You can just go to the "Query editor" and click "Refresh Preview".