+ Reply to Thread
Results 1 to 3 of 3

Power Query Extracting Data from Multiple Websites

  1. #1
    Registered User
    Join Date
    03-20-2020
    Location
    Minnesota, USA
    MS-Off Ver
    Office 365
    Posts
    11

    Power Query Extracting Data from Multiple Websites

    Hi All,

    I recently discovered power-query. I am using it to retrieve test results from Jenkins url. I took some guidance from an online article (unfortunately, I can't post a link since I'm a new member but if you search for let GetResults =(URL) => line in google you'll find it) , but I have to perform manual steps twice as each function I developed refers to a different table (pass or fail results). I already have two power-query functions defined "fgetPassResults" and "fgetFailResults". I am looking for help to combine these two functions, so I don't spend manual effort twice. I am happy to review power-query docs/forums for a solution.

    Note: This forum's guidance doesn't allow me to post any links if I'm a new member, so I can't be specific in my example at the moment.

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

    Re: Power Query Extracting Data from Multiple Websites

    You now have 10 posts and can post Links. As to uploading sample files, that has always been available to you. Check out the yellow banner at the top of this page.
    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
    Registered User
    Join Date
    03-20-2020
    Location
    Minnesota, USA
    MS-Off Ver
    Office 365
    Posts
    11

    Re: Power Query Extracting Data from Multiple Websites

    Thank you. Yes i read about sample sheets but didn’t have one without confidential data. Anyways, I was able to resolve my issue. Read through some Microsoft docs and was able to figure it out. closing this thread

+ 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. Quickbooks Multiple Data Sources, Power Query & Formatting
    By Keybler in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-10-2022, 09:14 PM
  2. Quickbooks Multiple Data Sources, Power Query & Formatting
    By Keybler in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2022, 07:56 AM
  3. [SOLVED] Extracting partial string from cells in power query
    By Nick Saunders in forum Excel General
    Replies: 5
    Last Post: 07-09-2021, 01:57 PM
  4. Extracting changes for different code elements from JSON data using Power Query
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2021, 08:12 AM
  5. Power query - unpivot data that has multiple headings
    By annaisakiwi in forum Excel General
    Replies: 11
    Last Post: 05-04-2020, 09:54 PM
  6. 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
  7. [SOLVED] Power Query to Extract Data based on multiple criteria
    By Philipsfn in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 01-16-2018, 01:45 PM

Tags for this Thread

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