+ Reply to Thread
Results 1 to 2 of 2

How to create dynamic source for a pivot table from a append table in power query

  1. #1
    Registered User
    Join Date
    10-16-2018
    Location
    turkey
    MS-Off Ver
    2018
    Posts
    8

    How to create dynamic source for a pivot table from a append table in power query

    Dear all
    I have 2 different tables in 2 different files. (my source files)
    I create a connection for these 2 source table (in a 3rd file)
    I use append command and I am able to merge these two tables correctly in PowerQuery.
    I load to this table to a sheet and I can do pivot table.
    But when my source are updated my results don't be updated.
    Because I need to create a pivot table with source of append table in power query.

    My question is how to create a pivot table and to have latest data when an update occurs in my source tables with power query?

    Best Regards.

  2. #2
    Registered User
    Join Date
    10-16-2018
    Location
    turkey
    MS-Off Ver
    2018
    Posts
    8

    Re: How to create dynamic source for a pivot table from a append table in power query

    I solved.
    I must refresh table in 3rd file.
    Then pivot is fine

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Query: Using a Parameter to specify a source table name.
    By learning new things in forum Excel General
    Replies: 0
    Last Post: 11-06-2018, 04:21 PM
  2. Add custom fields to a table to simulate a pivot table - Power Query
    By nathalielesperance in forum Excel General
    Replies: 2
    Last Post: 10-25-2018, 06:44 AM
  3. POWER Query and Power Pivot Table !!
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2018, 04:09 PM
  4. Power Query and Power Pivot Table
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2018, 06:17 AM
  5. Power Query and Power Pivot Table !!
    By haitham.shop in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2018, 06:15 AM
  6. POWER Query and Power Pivot Table !!
    By haitham.shop in forum Access Tables & Databases
    Replies: 0
    Last Post: 08-06-2018, 05:59 AM
  7. Replies: 5
    Last Post: 06-29-2018, 05:35 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