Results 1 to 3 of 3

new column in table after refreshing is removed - power query

Threaded View

  1. #1
    Registered User
    Join Date
    08-30-2009
    Location
    melbourne
    MS-Off Ver
    Excel 2016 / 2019
    Posts
    88

    new column in table after refreshing is removed - power query

    Hi,

    I am quite new to power query.

    Now I am importing excel files via power query. Then I add new columns set with drop down list and conditional formatting.

    When I add a new excel file (Data_3.xlsx) in the same folder and refresh the excel, I see those new columns (for this example, cause and Status columns) removed.

    Is there any way to keep those columns?

    Regards
    MK
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Query - Add another column to Table.TransformColumns
    By signup1 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 08-27-2021, 01:31 AM
  2. Replies: 0
    Last Post: 06-28-2021, 04:01 PM
  3. [SOLVED] Prevent user from refreshing power query
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2021, 06:01 AM
  4. Update pivot tables without refreshing power query
    By Acceptablerisk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2019, 04:48 AM
  5. [SOLVED] Refreshing only one power query query
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2019, 06:37 AM
  6. refreshing in power query
    By BORUCH in forum Excel General
    Replies: 3
    Last Post: 11-07-2017, 12:04 AM
  7. Power Query - add column with Table name
    By zico8 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-11-2017, 12:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1