+ Reply to Thread
Results 1 to 3 of 3

Power Query Only selecetd(parametrs) data to be download from source

  1. #1
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Power Query Only selecetd(parametrs) data to be download from source

    Hi all,

    Hope you guys doing well this serge

    I am new to PQ and i have been trying to figuer out if there is a way i can stream down the data from my source (CSV) wilth slecetd data parameters.

    For example i have gloabal data (APAC,UKI,USA) is there a way i can stream down only APAC rather than all the global from my source data .

    And my source data is in CSV and it is 600 MB file , just to avoid slow donw of quries i have been trying to use some tricks to pull down the data with slecetion.

    Thanks

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Power Query Only selecetd(parametrs) data to be download from source

    This video shows how to use parameters.

    https://www.youtube.com/watch?v=gK2yBpiITvI
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Re: Power Query Only selecetd(parametrs) data to be download from source

    Thanks alan it really worked .

+ 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. Replies: 6
    Last Post: 02-11-2021, 09:12 PM
  2. [SOLVED] Blank cells in Power Query, data existing in original source
    By kirootsouthpark in forum Excel General
    Replies: 4
    Last Post: 08-25-2020, 05:05 PM
  3. [SOLVED] Disable error alerts while running Excel Power Query to download web data HTTP Error '500'
    By naira in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2019, 05:02 AM
  4. Replies: 0
    Last Post: 01-14-2019, 12:59 PM
  5. 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
  6. Power Query Source vs Different PCs
    By flpneves in forum Excel General
    Replies: 1
    Last Post: 12-05-2017, 01:07 PM
  7. Dropbox Data Host/Source for Power Query
    By mielkew27 in forum Excel General
    Replies: 0
    Last Post: 04-09-2017, 11:49 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