+ Reply to Thread
Results 1 to 3 of 3

How to check if one query from Power Query was refreshed

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    How to check if one query from Power Query was refreshed

    Hi,

    i am still fighting with PQ and the issue is that refresh all based on dynamic parameter as path to external workbook is not working via VBA.
    What i have to do is to catch somehow that 1 table was refreshed.

    And after that trigger another macro in the loop. Otherwise Excel stops after refreshing one query.

    Do yoi have any idea how tyo catch this event?

    Jacek

  2. #2
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: How to check if one query from Power Query was refreshed

    I am trying with class "Class1" with code:

    Please Login or Register  to view this content.
    but this is not triggering after refreshing table...

    Best,
    Jacek

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: How to check if one query from Power Query was refreshed

    I am stop using PQ with dynamic reference to external workbook. It is causing so many issues...

    I am choosing standard way - so VBA and copying tables from external workbook to internal.
    No wortg go with dynamic parameter and PQ...

    JAcek

+ 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. Refresh all Power Query Pivots performing only 1 Query and stops
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2019, 04:49 AM
  2. [SOLVED] Power Pivot/Query Convert Existing Table to Query
    By trisoldee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-23-2019, 04:27 PM
  3. [SOLVED] Power Query Editor SQL - use query results in SQL
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2019, 03:20 PM
  4. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  5. Power Query: Check if Field contains text from list
    By learning new things in forum Excel General
    Replies: 0
    Last Post: 11-07-2018, 03:33 PM
  6. [SOLVED] Power Query - want to add formulas to query output
    By kersplash in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-19-2018, 06:16 AM
  7. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM

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