Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Proud to be a Super User!
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.
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.
You probably just have to edit your Power Query query. Depends on what you did in your query.
I did not find the option to edit. I did not do much in the query. Its just the import..
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |