• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Scrape Data from Multiple Web Pages with Power Query

You are here: Home / Power Query / Scrape Data from Multiple Web Pages with Power Query
Scrape Data from Multiple Web Pages with Power Query
May 21, 2019 by Mynda Treacy

Previously we looked at scraping data from the web by example, where the website paginated the data. That is, it spread the results over multiple pages. This week I’m going to show you how you can automatically scrape data from multiple web pages with Power Query using a custom function.

This approach works with URLs that have a predictable structure. Looking at the URL from the WorldCat website used in the previous post we can see in the image below there is a reference for the ‘start’ number highlighted in yellow:

WorldCat website

This start number is referring to the first record of 10 returned on the page. As we move through the pages of results the start number in the URL increments by 10.

Note: Not all URLs will follow this pattern. Some might use a sequential numbering system that refers to the page number, others might use text strings that relate to different regions etc. Either way, the process is virtually the same.

Download Power BI Desktop File

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Power BI Desktop File. Note: This is a .pbix file please ensure your browser doesn't change the file extension on download.

Watch the Video

Subscribe YouTube

Steps for Automating Scraping of Data from Multiple Web Pages

There are 4 steps required to scrape data from multiple web pages with Power Query. We did the first step in the previous post where we created a query that returns the first page of results.

In this post we’re going to look at the next 3 steps:

  1. Convert the query to a function that can be executed for each page of results
  2. Generate a list of page start numbers
  3. Execute the function for each page start number

Step 1: Convert Query to a Function

Starting off where we left the last example, we need to go to the Query Editor Home tab and open the Advanced Editor. Here we see the M code Power Query wrote for us.

We’re only interested in the first row that contains the URL for the web page. In this URL is the start number of the first record being returned on the page. You can see it magnified in the image below:

Scrape Data from Multiple Web Pages with Power Query

Each page returns 10 results, therefore the URL for the second page will have a start number of 11, and page 3 will have a start number of 21 and so on. We need to replace this hard-keyed value with a variable and convert the query to a function.

To convert the query to a function we add a line of code at the top for the variable name:

(PageStart as text) =>

I’ve called the variable ‘PageStart’. Then we replace the 1 in the URL with the variable name. Notice you need to append it with a double quote and ampersand on either side:

pagestart

Important: Power Query is case sensitive therefore you must enter your variable name with the case that matches the variable name. e.g. pagestart would return an error.

When you click ‘Close’ on the Advanced Editor you’ll see that the query is now converted to a function. I like to give my functions a name prefixed with ‘fn’ to differentiate them from other queries, as you can see in the Properties below:

query settings properties

Step 2: Generate Page Start Numbers

For this website we need a series of numbers for the variable which we’ll generate using Power Query, but other websites might use text strings. If so, you can import a table that contains your list of text string variables.

Ok, we’ll create a new query to automatically generate the list of page start numbers. Right-click in the queries pane > New Query > Blank Query:

new query blank query

In the formula bar we’ll generate a list of numbers 1 through to 21610 with the following formula:

= {1..21610}

This will return a list that we can convert to a table: List Tools Transform tab > To Table:

List Tools Transform tab

Add a Modulo column to detect every 10th number in the list (remember we only need the page start number and there are 10 records per page):

add a Modulo column

Filter the Modulo column for rows containing 1:

filter a Modulo column

This will leave us with a list of PageStart numbers in Column1 that we need for our variable:

list of pagestart numbers

The Modulo column has done its job, so you can click on the column header and press the Delete key to get rid of it.

Now, double click the header for ‘Column1’ and give it a proper name. I called mine ‘PageStartNumbers’.

We now have 2,161 page start numbers! Loading 2,161 web pages to scrape their data will take a very long time, so for the purpose of this example I’m going to filter them to the first 20 with a Filter for numbers less than 200:

pagestartnumbers

Next, I need to change the data type for the PageStartNumbers column to text, as it’ll be inserted into the URL, which is a text string. Click on the ABC123 icon in the left of the column header > Text:

ABC123

Now we’re ready to invoke the custom function we created in step 1.

Step 3: Invoke Custom Function

Add Column tab > Invoke Custom Function:

invoke custom function 1

At the Invoke Custom Function dialog box select the function from the Function query list and the PageStartNumbers column for the PageStart variable:

invoke custom function 2

Now we can expand the columns: click on the double headed arrow in the fnEysenckBooks column > Expand. Be sure to deselect ‘Use original column name as prefix’:

deselect ‘Use original column name as prefix’

You should see a list of books with title, author, type and publisher information.

delete the pagestartnumbers

You can delete the ‘PageStartNumbers’ column as this is no longer needed.

One of the great things about Power Query is that it maintains a connection to the web page which enables you to refresh the connection and get updates as needed.

Learn Power Query

If you’d like to learn more of Power Query’s wonders, please consider my Power Query Course. Or check out what Power BI has to offer, in my Power BI Course.

Scrape Data from Multiple Web Pages with Power Query

More Web Scraping Posts

Web Scraping Filling in Forms

Web Scraping – Filling in Forms

Automate your web browser with VBA to navigate web pages, interact with and fill in forms, submit the data and process the results.
Power Query Get Data from Web by Example

Power Query Get Data from Web by Example

Power Query Get Data from Web by Example is a new feature available in Power BI Desktop. It allows you to scrape data that's not in a structured html table.
web scraping multiple pages

Web Scraping Multiple Pages from Websites

Use Excel to load multiple pages from a website and get content from the pages you want. Sample workbook with code to download.
web scraping with vba

Web Scraping With VBA

Use VBA to read web pages and extract the data we want. Illustrated examples with sample code to download and use yourself.

More Power Query Posts

Power Query if Statements incl. Nested ifs, if or, if and

How to write Power Query if statements, including nested if, ‘if or’ and ‘if and’, which are easier to write than their Excel counterparts.
power query variables

Power Query Variables 3 Ways

Power Query Variables enable you to create parameters that can be used repeatedly and they’re easily updated as they’re stored in one place.
delete empty rows and columns using power query

Remove Blank Rows and Columns from Tables in Power Query

Delete blank rows and columns from tables using Power Query. Even rows/columns with spaces, empty strings or non-printing whitespace
extracting data from lists and records in power query

Extracting Data from Nested Lists and Records in Power Query

Learn how to extract data from lists and records in Power Query, including examples where these data structures are nested inside each other.
combine files with different column names in power query

Combine Files With Different Column Names in Power Query

Learn how to load data into Power Query when the column names in your data don't match up. Sampe files to download.
power query keyboard shortcuts

Power Query Keyboard Shortcuts to Save Time

Time saving keyboard shortcuts for Power Query that work in both Excel and Power BI. Download the free Shortcuts eBook
remove text between delimiters power query

Remove Text Between Delimiters – Power Query

Remove all occurrences of text between delimiters. There's no in-built Power Query function to do this, but this code does.
power query advanced editor tips

Tips for Using The Power Query Advanced Editor

Tips for using the Power Query Advanced Editor in Excel and Power BI. Watch the video to see these tips in action
pivot unknown variable number of rows to columns

Pivot an Unknown Number of Rows into Columns

How do you pivot rows to columns when you don't know how many rows you're dealing with? It's not as easy as you may think.
try otherwise power query iferror

IFERROR in Power Query Using TRY OTHERWISE

Using TRY..OTHERWISE in Power Query Replicates Excel's IFERROR So You Can Trap and Manage Errors In Your Queries.


Category: Power QueryTag: web scraping
Previous Post:Power Query Get Data from Web by ExamplePower Query Get Data from Web by Example
Next Post:Web Scraping – Filling in FormsWeb Scraping Filling in Forms

Reader Interactions

Comments

  1. Edyta

    May 26, 2022 at 3:47 am

    Hi,

    thank you for this post, very useful and the only one I could follow to get my API data from all pages.
    I have a question, as I expanded my columns after invoking custom function below row 208 I get an error “We cannot convert the value “” to type Table.” I checked and it seems there is an empty cell in one of the columns in the table… How can I fix this? None of the rows that should come after row 208 won’t load.

    Thank you in advance for your response!

    Reply
    • Mynda Treacy

      May 26, 2022 at 2:45 pm

      You can add a try otherwise clause to the custom function that handles the error. Bit hard to explain here.

      Reply
      • Edyta

        May 31, 2022 at 1:08 am

        Hi agan and thank you for your response. I tried doing as suggested but can’t get it to work. I understand with my function the problem appears when on expand steps, as there are some null values. Here are few lines of this part of first query that I turned into function – could you please give me suggestion of how to apply try..otherwise for one of these steps?

        #”Expanded projectComposition” = Table.ExpandTableColumn(Table0, “projectComposition”, {“leadResearchOrganisation”, “personRoles”, “project”}, {“projectComposition.leadResearchOrganisation”, “projectComposition.personRoles”, “projectComposition.project”}),
        #”Expanded projectComposition.leadResearchOrganisation” = Table.ExpandTableColumn(#”Expanded projectComposition”, “projectComposition.leadResearchOrganisation”, {“name”}, {“leadResearchOrganisation.name”}),
        #”Expanded projectComposition.personRoles” = Table.ExpandTableColumn(#”Expanded projectComposition.leadResearchOrganisation”, “projectComposition.personRoles”, {“personRole”}, {“projectComposition.personRoles.personRole”}),

        Reply
        • Mynda Treacy

          May 31, 2022 at 10:13 am

          Hi Edyta,

          Please see this tutorial on Try Otherwise.

          Mynda

          Reply
  2. Mohsen

    June 4, 2021 at 11:39 pm

    Hi Mynda,

    how can I get data from a website that needs to be logged in, in Excel by PowerQuery ?

    Reply
    • Mynda Treacy

      June 5, 2021 at 9:15 pm

      Usually it’s very difficult, especially if the website requires a form to be filled in. I don’t have an easy answer.

      Reply
  3. Rodrigo

    May 22, 2021 at 12:32 am

    Dear! Thank you so much for this video.

    Could you please share with us how can we do the following:

    I have a web based database that is constantly fed. Today it has 300 itens and 15 itens per page, so: 20 pages. But next week, this database may have 600 itens, and due that, 40 pages. How can I automate the function to identify the total number of the pages each time it acesses the web data source?

    Thank you!

    Reply
    • Philip Treacy

      May 22, 2021 at 12:18 pm

      Hi Rodrigo,

      So your system has no way of checking how any items/pages there will be? It really should have some way to do this, or at least provide you with information in each response (page) to indicate that there is more data yet to be retrieved.

      You’ll need to examine the response from the database each time you send a request. I don’t know what it sends you but I would expect that it either has a field/record that tells you there is more data to get,or it indicates that there is no more data, either by explicitly indicating this, or by the system generating an error to indicate the end of data.

      Without knowing how your system works I can’t be specific but these are the ways it should work.

      If you can provide examples of your system’s responses then I can assist further. Please start a topic on our forum and attach these along with your query.

      Regards

      Phil

      I would expect the system would tell you

      Reply
  4. Jay

    March 31, 2021 at 11:56 pm

    I am trying to extract the directory from this website https://www.kornferry.com/about-us/consultants?initial=A. There is a page click option at the bottom of the website.

    (PageStart as text)=>
    let
    Source = Web.BrowserContents(“https://www.kornferry.com/about-us/consultants?initial=”&PageStart&”),
    #”Extracted Table From Html” = Html.Table(Source, {{“Column1”, “H3 *”}, {“Column2”, “.article-item-back H3”}, {“Column3”, “.btn-arrow”}}, [RowSelector=”.isotope-item”]),
    #”Changed Type” = Table.TransformColumnTypes(#”Extracted Table From Html”,{{“Column1”, type text}, {“Column2”, type text}, {“Column3″, type text}})
    in
    #”Changed Type”

    I am getting the token comma expected error and it shows right at “Extracted Table” area.

    Q1: I could not find the error, could not find out where the error is
    Q2: I am able to extract data one page at a time but for multiple pages, i am missing something.

    Thanks in advance for any assistance

    Reply
    • Catalin Bombea

      April 1, 2021 at 2:57 am

      Hi Jay,
      I think the URL is wrong:
      Source = Web.BrowserContents(“https://www.kornferry.com/about-us/consultants?initial=”&PageStart&”),
      Should be:
      Source = Web.BrowserContents(“https://www.kornferry.com/about-us/consultants?initial=”&PageStart),

      Reply
    • Philip Treacy

      April 1, 2021 at 3:31 pm

      Hi Jay,

      That directory is displayed using JavaScript so you won’t be able to get it using Power Query. PQ can’t interact with dynamic page elements like that.

      You’d need to use something like Selenium/VBA that can actually send clicks to the page to update it

      https://www.myonlinetraininghub.com/web-scraping-filling-forms

      Regards

      Phil

      Reply
  5. Ben G.

    October 27, 2020 at 6:19 am

    I’m curious about how you would set this up for Power BI refreshes online. When I applied these steps and then published I got an error message about how Power BI service cannot refresh dynamic datasets. This is due to the URL being dependent on the parameter I guess. I came across this blog post.
    https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

    However, I can’t use the [RelativePath] field within Web.BrowserContents() M function, which I believe is what is needed for “Web by Examples.” It has to be the Web.Contents() option. Unfortunately there are slight disparities when I switch the function.

    Reply
    • Mynda Treacy

      October 27, 2020 at 9:17 am

      Hi Ben,

      Have you seen this post which talks about a workaround using Chris Webb’s technique. I hope that helps you overcome the problem.

      Mynda

      Reply
      • Ben G

        October 28, 2020 at 6:17 am

        That’s basically what I did but it required me to change the source to Web.Contents as opposed to Web.BrowserContents(). It caused a very slight discrepancy in the results when I made the switch. 99% of it was the same based on what I could see. Can you do web by examples with Web.Contents()?

        Reply
        • Mynda Treacy

          October 28, 2020 at 8:06 pm

          Hi Ben, Web.BrowserContents returns the HTML for the URL as viewed by a web browser, whereas Web.Contents returns the contents downloaded as binary. I guess this difference is enough to cause the discrepancy. You can try using Get Data > From Web and entering the URL to see if building it from scratch helps. Mynda

          Reply
  6. Maria Braga

    July 18, 2020 at 3:10 am

    Hi Mynda,

    Thank you for the content. Very useful! I will apply on some projects.

    On the project I’m working right now, I have a situation that cannot apply this and I’m not finding a good solution, maybe you have one.

    https://www.investing.com/economic-calendar/michigan-consumer-sentiment-320

    I am trying to export data from this website. The problem is that when you open the page, you have 6 values appearing, and when you update next month the last value will disappear, so you lost the historical data. If you click show more you’ll have the historical ones saved, but I cannot access them using Power Query. I check and nothing related with the page number appears on advanced editor.

    Do you have any suggestion?

    Thank you a lot!

    Reply
    • Mynda Treacy

      July 18, 2020 at 4:30 pm

      Hi Maria, It sounds like you’ll have to take a copy of the data before refreshing for the current month. You could try automating the copy and paste with VBA. Mynda

      Reply
  7. Sukesh

    April 21, 2020 at 10:24 pm

    Works like a charm. Thanks a ton for this article. Really helpful. I’m a complete newbie and yet was able to understand this easily.

    A couple of related questions: If I need two variables instead of one (say product ID and page numbers, instead of just the page numbers), will this work?

    Secondly, if the above is possible I need to specify page numbers based on Product IDs (both of which can be derived from the query and response), will it be possible? For instance: Product 1234 should navigate through 12 pages and Product 4567 should navigate through 20 pages and so on.

    TIA,
    Sukesh

    Reply
    • Mynda Treacy

      April 22, 2020 at 9:18 am

      Hi Sukesh, I’m glad you found this tutorial helpful. I’m sure you can provide multiple variables. You will need to generate them as one text string to feed into the URL, so you may need to concatenate other characters as required.

      Reply
  8. José Manuel Nunes

    April 15, 2020 at 7:55 pm

    Hi, thanks for a wonderful explanation.

    It worked fine for some sites.

    However, for a specific site I need to import data it won´t work,

    Could you help me ?

    https://digitarq.advis.arquivos.pt/details?id=1265252
    https://digitarq.advis.arquivos.pt/details?id=1265253
    …. and so on

    Thank you so much

    Reply
    • Mynda Treacy

      April 15, 2020 at 8:04 pm

      Hi Jose,

      It only works on web pages that contain tables inside of HTML table tags. I can’t see any tables on these pages.

      Mynda

      Reply
      • José Manuel Nunes

        April 16, 2020 at 10:14 pm

        Ah, Ok,
        Thanks !

        Reply
        • Philip Treacy

          April 16, 2020 at 10:43 pm

          Hi Jose,

          Perhaps scraping the pages using VBA would work for you:

          https://www.myonlinetraininghub.com/web-scraping-multiple-pages
          https://www.myonlinetraininghub.com/web-scraping-filling-forms

          Regards

          Phil

          Reply
  9. Eric

    January 15, 2020 at 11:01 pm

    Hi, thanks for a great post! I’m not experienced with power query, but worked through your example and got it to work 🙂

    Would it be possible to apply this to substitute several parts of an url? I.e to automate retrieving google search results with a list of search terms and i.e. five first pages of results? Any tips on how to approach this?

    Reply
    • Catalin Bombea

      January 16, 2020 at 3:34 am

      Hi Eric,
      All you have to do is to add as many parameters you need in the function arguments:
      (PageStart as text, Param1 as text, Param2 as text, Param3 as text)=>
      Then use those parameters in URL construction:
      URL=”x.com?p1=”&Param1&”&p2=”&Param2&”&p3=”&Param3

      Reply
  10. Alex Zaitsev

    November 23, 2019 at 12:13 am

    Thanks a lot! Works like a charm. I used it with Instagram API to iterate througn every media_id. I hope my comment would help others to find this article.

    Reply
    • Mynda Treacy

      November 23, 2019 at 9:14 am

      Great to know, Alex!

      Reply
  11. nani

    October 30, 2019 at 10:46 pm

    Hi There,

    Thank you for the great post.

    I have a similar situation but my API has a date field (yyyymmdd) and data changes with respect to the date.Is there any way that i can use custom date selection option and the data changes w.r.t the date. I tried the method you suggested above but this method brings all the data for the number of dates provided by me in the advance query (while creating a blank query).

    Thanks in advance

    Reply
    • Catalin Bombea

      October 31, 2019 at 1:14 am

      Hi,
      You can create a table with 1 column, 1 row, and type there the date you want.
      In power query, you will use:
      CustomDate = Excel.CurrentWorkbook(){[Name=”DateTableName”]}[Content]{0}[ColumnName]
      You will be able to use this CustomDate parameter in the rest of the query.

      Reply
      • nani

        November 6, 2019 at 4:35 pm

        Hi Catalin,

        Thank you very much for your help. The above steps provided by you work very well for a single API. However, I have multiple API like below. When I try to use the 2nd API with the same CustomDate, its not working properly.
        Ex: The below API has 1440 rows/day, when the 1st API is loaded its works fine but when the 2nd API is loaded, it is repeating the 1st row 1440 times and goes to the next 2nd row, repeats it 1440 times and so on. I’m not sure what I’m doing wrong here, can you please help me solve this issue.

        API Format:

        https://xyz.com/API/bike/dat/20191101/211_steer_1.json?
        https://xyz.com/API/bike/dat/20191101/211_bell_3.json?
        https://xyz.com/API/bike/dat/20191101/211_tire_1.json?

        Code from Advanced editor is as follows:

        let
        Source = Excel.CurrentWorkbook(){[Name=”pick”]}[Content]{0},
        #”Converted to Table” = Record.ToTable(Source),
        #”Changed Type” = Table.TransformColumnTypes(#”Converted to Table”,{{“Value”, type text}}),
        #”Invoked Custom Function” = Table.AddColumn(#”Changed Type”, “fn211_steer_1″, each fn211_steer_1([Value])),
        #”Expanded fn211_steer_1″ = Table.ExpandTableColumn(#”Invoked Custom Function”, “211_steer_1”, {“Column1.m64”, “Column1.m6”, “Column1.ts”},
        {“211_steer_1.Column1.m64”, “211_steer_1.Column1.m6”, “211_steer_1.Column1.ts”}),
        #”Invoked Custom Function1″ = Table.AddColumn(#”Expanded 211_steer_1″, “211_bell_3″, each 211_bell_3([Value])),
        #”Expanded 211_bell_3″ = Table.ExpandTableColumn(#”Invoked Custom Function1”, “211_bell_3”, {“Column1.m64”, “Column1.m6”, “Column1.ts”},
        {“211_bell_3.Column1.m64”, “211_bell_3.Column1.m6”, “211_bell_3.Column1.ts”})
        in
        #”Expanded 211_bell_3″

        Thank you for your help in advance.

        Reply
        • Catalin Bombea

          November 7, 2019 at 2:59 am

          You are using custom functions, I have no idea what those custom functions do.
          Take a look into a cell in column “fn211_steer_1″ from #”Invoked Custom Function” step. In that cell there should be a table produced by your custom function.
          If that table has more than 1 row, your next step to expand that column will also expand into rows, not just into columns.
          You should use our forum to upload sample files if you need more help.

          Reply
  12. Martin

    October 25, 2019 at 1:45 am

    Thanks Mynda, great article!

    This worked out well for me, except that it crashes every time when the page number does not exist.
    I tried a little to find out how to use error handling in PQ, but so far I didn´t find anything useful.
    If it doesn’t find the requested page, I want the function to move on to next in the list.

    Reply
    • Mynda Treacy

      October 25, 2019 at 3:46 pm

      Hi Martin,

      Error handling in Power Query is done with ‘try’ ‘otherwise’. This video by Miguel Escobar might give you some ideas.

      Mynda

      Reply
      • Martin

        October 29, 2019 at 6:54 pm

        Thank you Mynda. Much appreciated.

        Reply
  13. Eduardo

    May 29, 2019 at 7:04 am

    Ow Man, this is the best example of web scraping with power bi I have found on internet ever. Thank you very much!!

    Reply
    • Mynda Treacy

      May 29, 2019 at 8:58 am

      Thanks for your kind words, Eduardo 🙂 Glad it was helpful.

      Reply
  14. MF

    May 26, 2019 at 3:07 pm

    Hi Mynda,
    Seems there is a typo in the content:
    (StartPage as text) =>
    Should it be
    (PageStart as text) =>

    Reply
    • Mynda Treacy

      May 26, 2019 at 4:06 pm

      Well spotted, MF! Thanks. I’ve fixed it now.

      Reply
  15. Julian

    May 24, 2019 at 2:00 pm

    Hi Mynda,

    Thanks a lot for your quick response.

    Best regards,

    Julian

    Reply
  16. Julian

    May 23, 2019 at 12:40 pm

    Hi Mynda,

    For some websites, it’s a must to go through each page by manual to reach the last page. Is a way to automatically detect how many pages in a total then put that number in the query run?

    Best regards,

    Julian Chen

    Reply
    • Mynda Treacy

      May 23, 2019 at 1:21 pm

      Hi Julian,

      I’m not aware of any way to automate this. Usually the web page will have a ‘jump to end’ button. Sometimes it’s designated with two “>>”.

      Mynda

      Reply
  17. Andres

    May 22, 2019 at 1:32 am

    Hi Mynda,

    Great post, but I would like to combine both your last blogs and being able to scrape from example and to invoke a function. Now I have invoked a function, but the data retrieved is not correct, since it does not have an example which gives power BI the necessary data to create the desired output.

    I am sure it should be possible to do so, I just do not see how.

    Than you and kind regards,

    Reply
    • Mynda Treacy

      May 22, 2019 at 3:13 pm

      Hi Andres,

      If you download the Power BI file for this tutorial you’ll see that it does combine both get data by example and then invoking the function.

      Mynda

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.