![]() Now these image URLs, can be loaded into Power BI, with the Data Category as image, ![]() You can also rename columns to whatever you like, and then load that data into Power BI. You can also add the other information for each movie, so you can find out what movie’s image it is. Now in the Add table using examples, paste that value in the first cell ĭo this process one more time for the second image in the list,Įasy, wasn’t it? now you got all the image URLs! If you use Google Chrome as a browser, on the right click on an image, you can get the option for it Copy image address First, you need to get a couple of Image URLs as an example. The same method can be used for Image URLs. With just providing the first two values of any list, as an example, Power Query will find the structure to locate the section and get the remaining values The Add table using examples is particularly good when the data you want to fetch from the page is not in an HTML table, The example below, shows that I get data even from part of the page that is not a table. If you click on Add table using examples button (mentioned in the screenshot above), You will get a graphical editor, that you can enter some sample values, and tell to Power Query what is the value you are looking for, then Power Query will search for those values in the page, and use that structure as a template. the below example, is what I get when I use Get Data from Web of this URL for IMDB top 250 movies: However, those tables, usually cover the data, not link URLs, or image URLs. In Power BI (Power Query), when you get data from web, you get a list of tables suggested by the graphical interface of Power Query. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. ![]() For this method, you don’t need to look at the code at all. There is an easier way of doing it as well. That method, however, is what I call a bit of a techie way of doing it because you have to look at the HTML code of the page. I have written previously a blog article that I explained in detail how I fetch the image URL from a website using Power Query. ![]()
0 Comments
Leave a Reply. |