Results 1 to 1 of 1

Faster methods to read tables in power query

Threaded View

Undo Faster methods to read tables... 03-11-2023, 01:49 AM
  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    927

    Faster methods to read tables in power query

    Hello

    I am looking for the fastest way to read table in power query
    Which one is faster in power query, when source is
    = Table1
    so it will read table from query
    or
    Excel.CurrentWorkbook(){[Name="Table1"]}[Content]
    and this mean it will read from the sheet table
    or there is another way?
    Last edited by Undo; 03-11-2023 at 02:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Query - Feeding dynamic sheet name to Power query
    By egoosen3 in forum Excel General
    Replies: 5
    Last Post: 09-13-2023, 07:41 AM
  2. VB Code to Read Parameters into Power Query
    By dflak in forum Tips and Tutorials
    Replies: 1
    Last Post: 07-04-2021, 01:22 PM
  3. Power Query - can I make my query working faster?
    By afgi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-13-2020, 03:41 AM
  4. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  5. Replies: 31
    Last Post: 02-14-2020, 09:13 AM
  6. Excel Power Query Refresh or Access Query - 2nd Query Run is faster
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10: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